Mulitplying Fields in 2 Different Tables

A

Amber La Monte

We are moving from an Excel Time Sheet form into an Access Timekeeping
Database. I am trying to run a query that will multiply the number of hours
worked in 1 table, with another table that is containing the rate for that
type of work.

Could someone please just provide me a sample formula for this? Thank you!
 
K

KARL DEWEY

The two tables must have common information such as both contain the 'type of
work' performed. Then join the two tables in the query design view on the
common field.
Add a calculated field to the grid like this --
Labor_Cost: [Hours] * [Rate]
 
Top