Missing Record on Query

  • Thread starter Thread starter Lucie Chénier
  • Start date Start date
L

Lucie Chénier

Whenever I execute a query and there is a missing record in a field (not the
criteria field) which meets the criteria, this record is missing in the
result. Is there any reason for this behaviour?

Thanks,


Lucie Chénier
 
There's only one practical way for us to know: Show us the SQL. Open the
query in SQL view and copy and past it here. Information on primary keys and
relationships would be a nice touch too.

If there is more than one table involved, I already have a good guess.
There's not a matching record in the other table and you have an inner join.
You will need a left join to see all the records.
 

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

Access Dcount (multiple criteria) 3
Query Returning Multiple Results 1
query from combo 1
Selectively Update Field in Table 2
update query 2
query based on combo box on form not working. Coming back blank 1
Use In() Expression as Query criteria with guts from Function 1
Query question? 3

Back
Top