Sum expression in a Query


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
 
Ad

Advertisements

G

Guest

Think I have it:

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

Just checking if it has 'Sum'ed correctly
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top