Multiple table query coming up blank?

[Sharky II]

Hi guys. I have a customer table and a trip table. The trip table is linked to the customer table by a csutomer ID ( i don't know if that information is relevant right now).

My problem is this: If i create a query with only a few customer fields (and not any from the trip table), then all the records come up fine. But if i query multiple tables then i get no records coming up - a blank table.

Why is this? What possible reasons could cause this? I seem to remember it working once? I have entered the info correctly and the tables are populated so it's not like the tables are empty to begin with.

Can anyone help? I can supply as much info as needed!

Cheers!

 

[Sharky II]

oh, and querying each table individually (to only bring up records from that particular table) works fine, just when the two are combined, then the query comes up with no records.

 

[crook]

A couple of things to check...

1. Make your join a right or left join. In other words, right-click the link you created between your two tables, and select the option that says "show all records from X table, and only the records from Y table where there is a match"

2. Check your criteria. It could be that you've disqualified all of the data. I would suggest making a copy of the query, and then one by one, delete the criteria you have entered until some records are returned. (Re-run the query each time you delete a criterion)

3. Make sure both tables have at least some of the same customer ID's. If the join can't find any ID's that match, no records will be returned.

see if that works...