Searching for "invisible" values in Linked Excel table 1

[RippleJD]

I have a query in Access that is using a linked Excel table. I want to return only those records where the phone number is null. When I enter "Is Not Null" into the criteria for the phone number field, the result set still returns "blank" phone numbers. Excel is storing something in these cells that can't be seen in Excel or Access. How can I identify these cells and ignore them in the Access query?

Thanks

 

[braindead2]

<>&quot;&quot; will ignore them
=&quot;&quot; will find them

 

[PaulF]

There is a contradiction in your statement, you state that you want to show only records where the Phone # is Null, and then you enter Is Not Null in the Criteria Row, which will return all records with a Phone #s and those with zero length or blank spaces in them. If you want to return only Phone #s that are Null then use Is Null as the Criteria, or if you want to include all records that don't have any data in the Phone # field then use
Is Not Null Or = &quot;&quot; Or = &quot; &quot;
and if you want to exclude all records that don't have data in the Phone # Field then try either of these for the Criteria Row
NZ([Phone #],&quot;&quot<>&quot;&quot;
or
Is Not Null And <>&quot;&quot; And <> &quot; &quot;


PaulF

 

[RippleJD]

Thanks folks. I could have sworn I tried <> &quot;&quot;! I feel kind of silly now.

JD :~/