Records missing from query/report

  • Thread starter Thread starter MarshaM
  • Start date Start date
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!
 
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.
 
Back
Top