Is Not Null not working

[mtdew]

I have an Excel sheet where the date for field O83 is formatted General. In Access I want the query to only pull up the records where that field has data. I have tried:

Is Not Null
>01/01/2000
<>""
"*"
"/"
Like "*/*"

Nothing changes it. Unable to change format in Excel because the file is sent to me from large corporation in antoher state. What do I need to do?

 

[dhookom]

Try

Trim([YourFieldName] & "") <> ""

Duane
Hook'D on Access
MS Access MVP

 

[mtdew]

Nope. I can pull up the datasheet view and right click to remove all blanks and it works. I can create a filter on the query and it works. I copied the criteria logic from the filter query and pasted it into my query and it doesn't work.

 

[dhookom]

Can you share the SQL view of your query?

Duane
Hook'D on Access
MS Access MVP

 

[JonFer]

What about...

Len(Trim([Field]))> 0 (has 1 or more characters in it)

or

Like "*[0-9]*" (has a number in it)

 

[SkipVought]

I have an Excel sheet where the date for field O83 is formatted General.

Hmmmm??????? Strange!!!!

Why "field O83"??? Is that a cell? Why just ONE CELL? Why not the COLUMN???

You have a "date." It is "formatted General" If you had a REAL DATE column in Excel that was "formatted General," then the data would all be NUMBERS, like today's date: 40925!!!. So you must have TEXT, not DATE!


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]