Related tables and Queries

  • Thread starter Thread starter pfm721
  • Start date Start date
P

pfm721

I have a query that has 4 tables in it. When the query runs and the criteria
selected has information on all 4 tables it displays correctly. However for
instance if "999" is entered as the criteria in VetSSN, and tblVet has
information, but tblAppt does not because he doesn't have any appointment
information yet, the query does not display any of the information.
 
Your joins on the tables are set to display records only where data in all
tables match. Click on the join lines between the tables and edit the join to
the applicable option for what you are trying to display.
 
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

Using Collect Data with Related Tables 3
DELETING records from two tables 3
Linking tables in a query 1
DELETING records from two tables 2
Access Access Report Works on One Machine but not Another 3
Counting multiple memberships 1
Form with combo box to set criteria for query and report 2
Query Criteria stored in a table 1

Back
Top