Thanks for your help John here is the SQL on one of the queries which should give me 352 records but it is returning 0.
SELECT [MEDICC GENERAL DATA BASE].[Date Entered], [MEDICC GENERAL DATA BASE].[Last Name], [MEDICC GENERAL DATA BASE].[First Name], [MEDICC GENERAL DATA BASE].[E-Mail 1], [MEDICC GENERAL DATA BASE]. [Institution Name], [MEDICC GENERAL DATA BASE].City, [MEDICC GENERAL DATA BASE].[State or Province], [MEDICC GENERAL DATA BASE].Zip, [MEDICC GENERAL DATA BASE].[MEDICC Relation] FROM [MEDICC GENERAL DATA BASE] WHERE ((([MEDICC GENERAL DATA BASE].[MEDICC Relation])="salud")); --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > 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 >
