checkbox in table to show records in report

[Guest]

Hi all,

Probably an easy way to do this, and though I've looked around, havent found
it yet. I have two tables (Clients) and (Visits), a query which is the
source of a report (Billing). On (Visits), I have a checkbox which can be
checked if that particular record has been billed for. What I want to have
happen is when the query is run (to create the dynaset for the report), I
only want those records which HAVENT been billed for to be displayed (the
report is an invoice type report). I understand the concept of the =True or
=False of the checkbox, but am not sure how to work that into the set up I
have. Any assistance would be deeply appreciated.

Dave

 

[Jeff Boyce]

Dave

It sounds like you have a query you use as a source for your report.

Open it in design mode, add the "checkbox" field, and in the criterion
"cell" under that field, use either =False or <>True.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

PERFECT!! Thanks Jeff.

Dave

It sounds like you have a query you use as a source for your report.

Open it in design mode, add the "checkbox" field, and in the criterion
"cell" under that field, use either =False or <>True.

Regards

Jeff Boyce
Microsoft Office/Access MVP