Selecting null values with report criteria

Question

I'm trying to build a report that will allow me to select job costs for a list of jobs that have no work order assigned. How do I set the criteria to select null values?

ghollister · Accepted Answer

For the Work Order# field, you could use the operator "Less than" "0". This should display only job cost records where the Work Order# field is empty. This can also be done with a query in the 6-3 Job Costs window. That field actually does not have NULL values, it's just simply empty until a work order# is added.

Sage Construction & Real Estate

Selecting null values with report criteria

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING