RE: [ms_access] Query won't show all results
Brad This may sound silly or I have missed a posting ..But, is it possible that you have spaces in the empty fields??? This will appear to your sql as a field that is NOT empty. you may have to try and run a trim function on the field this will remove any empty spaces cheers John Y At 09:21 AM 29/09/2009, you wrote: run the query with a *x* around the criteria.. see if you get all the records No. I am trying to create a query to eliminate blank fields in a column. There are close to 14,000 entries, 6070 are blank (when using a filter). When I set IS NOT NULL as the criteria, it only hides 4514, leaving 1556 blank fields still visible. Likewise, if I use IS NULL it only shows 4514 of the blank fields. I've checked some of the fields and they really are empty, even the ones that don't work. It's really more of an annoyance as I can always just use the filter whenever I need to eliminate the blanks. This is in Access 2007, I don't know if it was the same in older versions. Brad [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
Re: [ms_access] Query won't show all results
But, is it possible that you have spaces in the empty fields??? This will appear to your sql as a field that is NOT empty. Wouldn't that also be the case when filtering for an empty field? I checked several of the fields and they are empty, plus I can't imagine how it would happen over 1500 times. Some of the data may have been cut and pasted from an Excel file, but that applies to the ones that are working as well. When I run a filter in the IS NOT NULL query on the blank fields for Does NOT equal blank, it hides all the rest of the blank fields. I'll have to double check for spaces and such tomorrow, it's getting late here. Brad [Non-text portions of this message have been removed]
Re: [ms_access] Query won't show all results
My data is sound (I've spot-checked) , it's just that the query stops at a certain point. Why? How do I fix? I have the same problem. Brad [Non-text portions of this message have been removed]
[ms_access] Query won't show all results
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?