calculations with a multi-table query

[Jason]

anyone know how to setup up calculations within a multi-
table query?

 

[Kevin G. Sprinkel]

-----Original Message-----
anyone know how to setup up calculations within a multi-
table query?

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

 

[John Vinson]

anyone know how to setup up calculations within a multi-
table query?

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.