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.
 
Back
Top