Microsoft Query does not return all of the available records.
Make sure you haven't limited the number of records to return Make sure the number of records to be returned has not been restricted. Click Options on the Edit menu, and then make sure the Limit number of records returned to check box under User settings is cleared.
Check your criteria Make sure any criteria you have specified are entered correctly, so that they retrieve the records you want. For more information about specifying criteria, click 
.
Check your joins Make sure any joins you have created have the desired effect. For more information about joins, click .