How to troubleshoot query?
Absolute novice
Windows XP 
Access 2007
I am doing a simple query of a table of student's particulars. I'm just doing a very simple query of <First Name> and <Last Name>.
However, many of the records are not showing up. E.g. there are 159 records in the student table, but in the query, only 34 records are showing up. I have not set any kind of criteria or filtering in my query.
How do I troubleshoot this so I know why they're not showing up? Thanks.
Administrator
Windows 7 64bit Access 2010 32bit
Post the SQL View of your query so others can see, please.
Absolute novice
Windows XP Access 2007
I'm sorry, I tried it using the Query Wizard and it worked, so I had deleted the old query. Sorry about that.
Administrator
Windows 7 64bit Access 2010 32bit
That's okay! The main point is you resolved your issue. Great! Thanks for posting back.
Posting Permissions
Reply With Quote