marilynt01
Technical User
My query isn't returning any records, but i know there are matching records in my table. How could this happen?
Thanks,
Marilyn
Thanks,
Marilyn
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Query returns no records- but i know there are matching records
- Thread starter marilynt01
- Start date
- Status
Dear marilynt01,
Go into the Design view of the query and right click on the (grey) area containing the tables which are included in the query
Select SQL view,
copy the Text and paste it in here so we can see it.
Makes it quicker to find the problem and offer a solution if we know the names of the Tables and the Criteria etc that you are using.
Regards Jim
p.s This really belongs in the
Access2 Queries and JET SQL forum
No problem, just that you will generally get a quicker answer from the many Query experts who 'loiter' there
Go into the Design view of the query and right click on the (grey) area containing the tables which are included in the query
Select SQL view,
copy the Text and paste it in here so we can see it.
Makes it quicker to find the problem and offer a solution if we know the names of the Tables and the Criteria etc that you are using.
Regards Jim
p.s This really belongs in the
Access2 Queries and JET SQL forum
No problem, just that you will generally get a quicker answer from the many Query experts who 'loiter' there
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question