Records missing from query/report

M

MarshaM

Database of +7000. Query has criteria of sort by Doctor which points to
Doctor table. 2 Doctors have no results returned even though the individual
records are there. No extra filtering is involved and these look just like
all the others who have results returned. Help!
 
J

John W. Vinson

Database of +7000. Query has criteria of sort by Doctor which points to
Doctor table. 2 Doctors have no results returned even though the individual
records are there. No extra filtering is involved and these look just like
all the others who have results returned. Help!
Click to expand...

Correct the error in your query (or perhaps in your data).

If you would like help doing so please open the query in SQL view and post the
SQL text here, together with the values from the relevant fields in the two
tables.
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Access Query to import from Sharepoint 0
removing records that look like duplicates but aren't 7
Query wont show records 4
Problem counting 5
Records Missing from Report 3
query criteria eliminates too many record results 1
Using IIF In Query Criteria 4

Top