Query comes up empty

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created 3 tables and made a query with the query wizard but when I run the
query the data I entered into the tables does come up. It shows no records.
 
Hi,


It may be that the WHERE clause (criteria) does not find any record, or
that the INNER JOIN does not find any match.


Remove all the criteria, do you get records? if so, one of your criteria is
too restrictive, or involve a typo (like ="L0" rather than ="LO"
wanted ).
If you still have no record, remove one of the three table. If you now get
records, the join(s) between that table and the other two "does not find
matching values". If you still do not get records at this point, the actual
join that are still present in the query does not find matching values. You
should get record if you remove these join(s), or if you redefine them
appropriately.



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top