I have a query with criteria captured from two fields in a form.
For example:
[Forms]![ScaleLogSpreadsheet]![ComboName]
[Forms]![ScaleLogSpreadsheet]![ComboBatch]
How do I get the criteria to work so that it shows all records if both fields are blank and also works if one of the fields is blank. I believe that I need to use IsNull, but I do not know where to put this in my criteria.
Thanks.
For example:
[Forms]![ScaleLogSpreadsheet]![ComboName]
[Forms]![ScaleLogSpreadsheet]![ComboBatch]
How do I get the criteria to work so that it shows all records if both fields are blank and also works if one of the fields is blank. I believe that I need to use IsNull, but I do not know where to put this in my criteria.
Thanks.