Hoping this will be easy

[Stuartdls]

I have hit a total blank.
When you run a query for blank fields i.e. "is null" or "". It will return all the records with no data in the selected field...

basically i want the opposite to that.

I want to search for any records that have data in...and leavoe out the blank ones. Any idea?

Thanks in advance

 

[KenHigg]

'is not null'

 

[Stuartdls]

doesnt seem to work...or were you just being sarcastic?

 

[Stuartdls]

dont worry...sorted. thanks anyway people

 

[KenHigg]

I was trying to help. What did you use?

 

[boblarson]

It SHOULD be -

Is Not Null AND <> ""