I have a list of applicants and on their record is a field for “year”. Some have it and some do not.
Can’t seem to create a report that shows me just the records where YEAR = BLANK …or EMPTY or NULL
What doesn’t work:
—Leaving it blank - yields no records
—Making all the years that are present as “Not Equal To”
—Double quotes
Anyone figure this out? This logic must be in use elsewhere, no?
I think this is a deal breaker for us. Our data for each student doesn’t always come at once and we need to see on a regular basis what’s “missing”.