Query using multiple tables

D

Dave B

I have 2 tables, one contains ID number, date, Company ID, DriverName, Miles
and Hours. The 2nd table contains Driver name, SSN, 2 other numbers, and
PayMiles and Pay Hours. The DriverName field is indexed in both tables. The
Drivre Name filed in both tables is connected.

When I develop a select query using both tables I get blank results. I can
do a query using the 1st table and ask for a certain date and the information
shows properly.

What is the secret to getting all of the 1st table information as well as
the Pay Miles and Pay Hours from the 2nd table?
 
G

Golfinray

Right click on the line between the two tables and it will give you 3
options. Select the second.
 

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

Left Join Question 2
The query cannot be completed. 1
Comparison Query - How to write it! 6
RelationShips Queries and joins 10
Combine multiple tables with different date ranges 2
Queries with Linked Tables 5
Query problem (MS SQL and MS Access tables) 2
Query with two date field for Date range 3

Top