Hey All!
How do I make a criteria in a BAQ so that it only pulls entries that have data in that column? I know this is probably pretty easy but I can’t seem to crack it.
Thanks!
Add a criteria of field <> a constant value. Then when you click on constant, hit Enter and it will give a null for the constant.
And don’t forget that null and empty string aren’t the same thing, so check for both:
where
YourTable.YourField is not null
and YourTable.YourField <> ''
The first one is a matter of selecting the ISNULL comparison criteria and ticking the Not checkbox.
The second you can compare to a criteria value and leave it blank, or compare to an expression and provide it with ''.