Need more info. What's the SQL of one of the queries, what result are you getting, and what result to you expect? To find the SQL, open the query in Design view and choose SQL View from the View menu.
John Viescas, author Microsoft Office Access 2007 Inside Out Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of tuck1025 Sent: Monday, August 20, 2007 2:40 PM To: [email protected] Subject: [ms_access] Query Doesn't Return all records I am running some basic queries on an access database and after manually scrolling through the table I realized that some of my queries are only returning half of records it should be giving me. Any suggestions on why this might be happening? Thanks so much for any help. Yahoo! Groups Links
