Math problem

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

Hi all,
I`m creating a database for a store.
How do I build a quary that make a calculation of price times Quantity for
each product and then to get a sum of all?
 
Two separate queries might be easier for you.

The first will be a query of your original table.
Put all the fields you wish, into it. Then, in a blank collumn in the query, type ABCDEF:[price]*[quantity]
save the query, as Query1 for example
create a new query, based on Query1; add the ABCDEF collumn to the query. Add it again.
Click on the sum symbol at the top of the tool bar; it looks something like a capital E.
Back at the bottom of the screen, use the pulldown box to pick "Sum"
run the query, and you're done.
 
Back
Top