467,077 Members | 935 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,077 developers. It's quick & easy.

Access Report - selecting detail records to print

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.
Apr 19 '07 #1
  • viewed: 1663
Share:
1 Reply
ADezii
Expert 8TB
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.
Apr 19 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Dale Ring | last post: by
1 post views Thread by David Horowitz | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.