Query from multiple tables

  • Thread starter Thread starter Anthony
  • Start date Start date
A

Anthony

I have 2 tables that I want to pull data from. One table contains
productivity data that logs staff start/end time. The other logs staff days
off. I want to be able to pull bother together to create a timesheet report.
I've created the query; however, when I go to run it..it comes up blank.
Any suggestions?
 
I have 2 tables that I want to pull data from. One table contains
productivity data that logs staff start/end time. The other logs staff days
off. I want to be able to pull bother together to create a timesheet report.
I've created the query; however, when I go to run it..it comes up blank.
Any suggestions?
Click to expand...

Since you give us no information about how the tables are related or about the
nature of your query, it's a bit hard to answer.

If the two tables have the same basic structure and you want to logically
"append" records from the staff log to the staff days off, I'd GUESS that a
UNION query would work, but without more info about your structure that's just
a guess.
 
Back
Top