Missing Record on Query

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
 
J

Jerry Whittle

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