I am having trouble with the Specify Find Request.

There are several fields that need to be examined:

email

DOB (Date of Birth)

DOP (Date of Passing)

I need to be able to find all the records where:

email is not empty

and

DOB is not empty

and

DOP IS empty

The problem lies in trying to specify the DOB for example.

When I specify <> isempty(Members::DOB) or NOT isempty(DOB) I get an error reminding me that my date is out of range.. huh???

What am I missing Thanks

Either with:

Perform Find [ email criteria: * ; DOB criteria: * ; DOP criteria: = ]

or ( better at least for me ) :

Enter Find Mode [ ]

Set Field [ YourTable::email ; "*" ]

Set Field [ YourTable::DOB ; "*" ]

Set Field [ YourTable::DOP ; "=" ]

Perform Find [ ]

Worked like a charm! I was operating under the 'assumption' that using * would include "". Thank so verrrrrrry much!