E
Ernest Lai
Hi all.
I have a database with product prices. Columns like product pice, vat,
total price.
I want to create a table via query that will give me one line of info.
Todays date (not that important)
Total cost of product
Total vat
Total price
All on a line
Basically I know you can enter 'Expressions' Into the field. Something like:
Expr1: Format(Sum(INT(labour value)))
Thanks in advance, any help is much appreciated
Ernest
I have a database with product prices. Columns like product pice, vat,
total price.
I want to create a table via query that will give me one line of info.
Todays date (not that important)
Total cost of product
Total vat
Total price
All on a line
Basically I know you can enter 'Expressions' Into the field. Something like:
Expr1: Format(Sum(INT(labour value)))
Thanks in advance, any help is much appreciated
Ernest