calculations with a multi-table query

  • Thread starter Thread starter Jason
  • Start date Start date
-----Original Message-----
anyone know how to setup up calculations within a multi-
table query?
Click to expand...

It's the same as for a single table, except refer to
fields with the table name, as in:

[tablename].[fieldname]

For example, to calculate an extended price from a unit
price stored in the Products table and Quantity stored in
the Order Details table, enter the formula:

[Products].[Unit Price]*[Order Details].[Quantity]

Kevin Sprinkel
Becker & Frondorf
 
anyone know how to setup up calculations within a multi-
table query?
Click to expand...

Yes; just type the expression in a vacant Field cell in the query
grid.

If you'ld like a more detailed answer, please post a more detailed
question.
 
You must log in or register to reply here.

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

Similar Threads

Calculations, Queries and making it all come together in my table 4
Adding tables in SELECT query, messes up Sum calculation 5
Searching for Records in a Report 1
query to combine values if true 6
Merge fields on a query table 1
Firefox Multi-Account Containers 1
Calculation In Query 1
Don't understand the relationship between a combo box and a table 15

Back
Top