Only display pending orders in report?

[AThomas]

Hi guys,



I'm trying to create a report that will only show entries where the 'Paid' checkbox value is true and the 'Dispatched' checkbox value is false. It's been a long time since I've done anything in access and all the syntax has long gone from my memory.

Can anyone help?

Thanks,

Ash

[jzwp11]

Welcome to the forum!

You can create a query that does the filtering for you. Then you would base the report on that query.

[AThomas]

Ahhh thanks very much, I don't know why I didn't think of that in the first place to be honest.

[jzwp11]

Another option would be to leave the report based a table or query that returns all records, but use a form to control whether all records or just the pending records are shown in the report.

To do this, I typically use an unbound form with either an option group or a combo box where the use chooses which version of the report they want and then they would click a button. In the code behind the button you would either just open the report unfiltered or filter the report as it opens based on the selection made by the user.

[AThomas]

Thanks, that's a brilliant idea. I might try and give that a go but I'm not sure whether my access skills are up to it to be honest... like I said, it's been a while.

[jzwp11]

I've attached an example database that illustrates the code necessary. Just open the form: frmReportSelect.