How to Do a multi field search

[FritzOK]

I

[jasonwood]

Put the date criteria in the date field, then put "=" in the fields which must be blank. You could also check the "OMIT" box since these are the records you *don't* want... or you could perform the find and then choose "Show Omitted"

[FritzOK]

If I do the Find/Omit with = in the 2 fields that works. If I do the Find/Omit in the date field with the proper info, that works. But the combination doesn

[djgogi]

What do you mean with "combination" ?

if you have 2 separated Find Requests than you are performing an OR find between them.

Instead you should have only one Request with omit option selected.

The result would be all records that do not satisfy the date criteria AND that don't have other fields empty + records that satisfy data criteria but don't have other fields empty + record that don't satisfy the data criteria but have other fields empty

Dj

[FritzOK]

I

[andygaunt]

You want a list of those records that have the date AND the two fields empty.

This really means find me those records I HAVE a date for AND (which is a new request ) This first field is empty AND (which is another new request) this second field is empty.

Otherwise you are looking for where you have the date field and the other two fields are empty on the same record. The record has to match ALL the criteria to be found, whereas you want it to find where ANY of the criteria are a match.

HTH

[djgogi]

This really means find me those records I HAVE a date for AND (which is a new request ) This first field is empty AND (which is another new request) this second field is empty.

This is an "OR" not an "AND"

The above should be read as

This really means find me those records I HAVE a date for OR (which is a new request ) This first field is empty OR (which is another new request) this second field is empty.

[FritzOK]

the REquest menu item was a concept I was missing. Got it now.