Show if one of the fields are null or not check.

[cstuckey56]

Can you tell me how to run a report to show a Client if one or of the following fields are blank or unchecked(Yes/NO?

Fields
Client
Assessment Date(Null)
Placement Fee Paid(Check Box)(No)
TJ Completed(Check Box)(No)

So basically, if one of the above fields are null or unchecked, please show in the report. I'm sure it's easy but to do, but not up on coding. :banghead:

Thanks

 

[Beetle]

You would need criteria like the following;

Where [Assessment Date] Is Null Or [Placement Fee Paid] = False Or [TJ Completed] = False

This criteria could be applied to a query which could then be used as the record source for a report, or it could be applied directly to a report in the Where condition of the OpenReport method.

 

[cstuckey56]

Can you be more specific. I can't get the criteria to work.

 

[boblarson]

Can you be more specific. I can't get the criteria to work.

If it is a true Yes/No field, you just put

FALSE (no quotes)

or

TRUE (no quotes)

in the criteria (if you are using the Query By Example Grid).


And for the date field the criteria in the QBE Grid:

Is Null

or

Is Not Null