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.
 
Back
Top