Sum expression in a Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Think I have it:

Expr12: Format(Sum(Int([Invoiced Value])))

Just checking if it has 'Sum'ed correctly
 
Back
Top