I have a table where there is a checkbox for "Enrollment" and then a second field with a month. What should my query look like if I want to pull all records out where the checkbox is true but the month specified doesn't exist in the record.

Example Table (looking for the second field to be true but no July record):

Account | True | June
Account | True | July
Account2 | True | July
Account3 | False| null
Account4 |True | null

"Account" has a July record so this record should not pull
"Account2" has a July record so this record should not pull
"Account 3" is False so should not pull
"Account 4" is true and has no July - so this record should pull

Thanks in advance!

Dear hraup

You have to simply write down "Is Null" in month criteria and "true" in Account criteria.


Thanks.

Wasim