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.
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...