Search results

Hi again What eagle eyes! Great stuff, it works a treat. Thanks very much for your time and help really appreciated. Where can I find details of coding and code building. I am familiar with Access, but this is different again. eg SUM(CAST(Field4 as INT)) Many Thanks Lyndon

If anyone can help I have a field on my scanner, showing the sum of the units I have scanned. This is a running total for information only. But I cannot get it to work. Can anyone help.

Thanks for the info I will post, here a copy as suggested. Regards Lyndon

Hi Dan Its killing me, just cant get it to work. I have named the field as 4 as this is the field I need to sum. Think this is correct but still nothing shows in the field. Can you see anything else that may be the issue. SELECT SUM(CAST(Field4 as INT)) AS s FROM Session1 WHERE Field...

Hi Dan Your first fixed worked a treat. Still struggling on the second a bit Think Ive done it ok, but no joy as yet. I have attached two screen shots,wondered if you would check for me. Regards Lyndon

Hi Very new to TP I’ve designed a very simple stock inventory solution. One session to scan, fields includes Current stock. Description Scan qty. The other session holding lookup table. 1. I need to prevent the software from adding a product/barcode that is not present in the...