FIND & SEARCH in Queries

[adario]

I'd like to do a FIND/SEARCH in my records.

in QUERY, I tried writing a few expressions that didn't work... can someone help me?

1. In QUERY, I want to find all records for which the COUNTRY field is blank. Shouldn't it be something like =" "

2. In another QUERY, I want to find all records for the COUNTRY field where there is information. I've got something like this
><" "

Please help, I'm failing miserably!

Tks,
Amy

 

[Randi A. Dertzo]

In your queries try to replace = "" with IS NULL and <> "" with IS NOT NULL.

 

[adario]

Thank you! It worked.

Amy