I am using MS Access 2003. I have a form with a few dozen combo boxes that will generate a report according to the data chosen once a button is clicked and the filter applied.
The combo boxes are created from each field in a table. If the field "dtmDateOfService" combo box choice is 1/1/2011 then I only get a report with records that have that "Date of Service". If a "Date of Service" is not filled in then a blank shows in the combo box. I don't have a problem wtih the blank since they may want to see a report with those records that have not been assigned a date yet. I have a problem because the report is incorrect. When I choose the blank from the combo box and apply the filter I see all of the records even though there is only one blank. Since the blank that shows in the combo box comes from the blank in the table I don't understand why it won't find only the one record.
I have tried many different ways to come up with this blank record but nothing works. Can someone please help? Thanks in advance!