Only print items that have a checked checkbox?

[dmon2010]

Hello, I've been using MS access 2007 but am still pretty green.



I have a form where I enter an order number, then click a button. This runs a query and opens a report that lists all of the corresponding entries with the matching order number.

The way I have the report set up right now, each item on the report has 2 buttons. One button creates an acceptance report, and the other button creates a discrepancy report.

What I'd like to do is have a check box for each item instead of the 2 buttons. I would like to be able to check one or more items and have a single button for acceptance reports (or discrepancy reports) at the bottom. Ideally, this would add the totals for each item (not count each item) and create single acceptance report for the grand total of all items.

Is this possible to do?

Here's an image of the existing report as it is now...

Any help would be greatly appreciated. Thanks in advance.

[ranman256]

yes, in the table, add a field ACCEPTANCE as a YES/NO type.
In the Acceptance query , youd pull only those.
select * from table where [Acceptance] = true

[ssanfu]

The way I have the report set up right now, each item on the report has 2 buttons.

Why are you doing this in a report?
It would be better to use a form.

As ranman said, have a Boolean field in a table to be able to select the records to be printed.
Would need 3 buttons:
A button for the acceptance report
Another button for the discrepancy report
Button 3 to un-select (un-check) the selected records.

[dmon2010]

Yeah I realized that a form would be a better approach. Changed the report to a form, but still having a difficult time getting it right. Can't seem to get it to sum the quantities... and how would I have the 3rd button un-check the checked records?

Thanks

EDIT:

Figured it out. Thanks for the help!