check the format of the data fields.. If you are looking for an exact match, there might be a hidden character or space that will not sow up in the query
--- On Thu, 9/24/09, danvers70 <[email protected]> wrote: From: danvers70 <[email protected]> Subject: [ms_access] Query won't show all results To: [email protected] Date: Thursday, September 24, 2009, 1:37 PM Using Access 2007, I have a large table with about 15k entries. I have a simple query to pull out a certain membership type based on a text field, but the query only displays up to about 700 entries when I know there should be almost 1200. My data is sound (I've spot-checked) , it's just that the query stops at a certain point. Why? How do I fix? [Non-text portions of this message have been removed]
