Check box and filter form
Posted on 2011-02-28
I have a report with a filter form.
I need to inlcude or exclude records based on chkExpiredYN is checked or not checked.
The underlying table is tblLetterOfCredit and the qry field is [ExpiredYN]
[ExpiredYN] is a value list with "Yes";"No" as rowsource.
If the chkExpiredYN is checked on filter form then inlcude ALL records with "Yes"
If chkExpiredYN is Null then exclude records with a "Yes" under [ExpiredYN] but include Nulls too
How would I write this in the SQL?
(you can make up a form name for this filter form)
I am really lost on this. I seem to not be able to qry the table for records that are Yes or No either for this [ExpiredYN] field. I type in ="Yes" but the qry includes all records and not just then ones with "Yes". I also use <>False and it does return records with a "Yes" but if I use <>True then it returns the same records as it did for <>False. I dont understand this.
I dont know if a checkbox is recommended under the filter form or a Yes No field.