Mulitplying Fields in 2 Different Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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]
 
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

Date relationship to a table 6
Calculate field with input from different table 5
2 Relationship Query 1
Simple (?) report? 2
Carrying a value between 2 tables 3
Formula Help 1
Calculated fields with unrelated tables 8
Forms and 2 tables 3

Back
Top