I have an Access report. In the source table of data I have a check box, dlyBillCode, which is checked if I want that record to be included in the report.
That dlyBillCode itself doesn't appear anywhere on the report.
What's the best way to do this? Looking at my book it appears I could either do an IIF or use a filter in the properties for the report. I couldn't get either one to work.
I couldn't figure out the IIF because the example in the book uses a field that appears on the report, which mine doesn't. I tried the filter by going into the properties for the report and then on Filter I typed in dlyBillCode= true (is that the right way to test a check box!!) and then setting Filter on to Yes. but it just didn't have any effect on the report.
Any help would be appreciated, thank you.
Change the underlying RecordSource of the Report from a Table to a Query. Include the [dlyBillCode] Field in the Query, and set the Criteria in this Field to True.
