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))
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...
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.
Very new to TP
I’ve designed a very simple stock inventory solution.
One session to scan, fields includes Current stock.
The other session holding lookup table.
1. I need to prevent the software from adding a product/barcode that is not present in the...