Finding Null values in a field - HELP

[chrisl]

Howdy All:

I have a quandry i would like help on:

I have a database i am rebuilding ( About 245 layouts with more than 900 fields) - I know!

I am trying to clean up the data by process of searching and eliminating certain records. I have criteria for about 6 fields to search, but the last three fields are looking for NULL data:

IE:

Doc Date (omit) Null

Billing Date (omit) Null

Results (omit) Null

I have the add request thing down pretty good, but how do I specify to FileMaker that I want to search for this NULL data in these fields?

If this is a very simple question, please feel free to e-mail me a Cluepoun with your answer.

Thanks again!

Nitewolf

[LiveOak]

Just enter an equal sign "=" into the field. This matches a blank field (leave out the quotes).

-bd

[chrisl]

bd:

Thanks for that. It worked! I am going to post another Q to the list, maybe you can take a look.

Thanks in advance!

Nw