B
Bob
I am using a query by form to select and print specific records from a
table. One of the fields in the table is a yes/no field which I want to
reference in my query by form. At present if I check yes in the query by
form the query will return records with a yes value in the table and if I
leave it blank it will return those records that have a no value. I would
like to modify this so that if I leave it blank the query will return all
records. Is this possible and if so what expression should I use in the
query criteria for that field? Thanks in advance.
Bob
table. One of the fields in the table is a yes/no field which I want to
reference in my query by form. At present if I check yes in the query by
form the query will return records with a yes value in the table and if I
leave it blank it will return those records that have a no value. I would
like to modify this so that if I leave it blank the query will return all
records. Is this possible and if so what expression should I use in the
query criteria for that field? Thanks in advance.
Bob