Blank Checkbox Report

[SR7133]

I have a database with a checkbox which indicates if an invoice has been paid
or not. I am trying to create a report which will show only the empty
checkboxes indicating that the invoice has not yet been paid. Can anyone
assist please? Many thanks in advance

 

[scubadiver]

I would base the report on a query using a filter. In the criteria row for
the checkbox put a

-1

 

[boblarson]

Set the underlying recordsource of the report to be a query, instead of the
table (see here how to change:
http://www.btabdevelopment.com/main...dsourcefromtabletoquery/tabid/75/Default.aspx )

and then in the criteria of the paid, put FALSE.
--
Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP

Tutorials at http://www.btabdevelopment.com

__________________________________

 

[boblarson]

scubadiver -

That would give the opposite of what they wanted. They said they wanted the
ones NOT paid, so the checkbox criteria should be FALSE (0) instead of TRUE
(-1).
--
Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP

Tutorials at http://www.btabdevelopment.com

__________________________________

 

[SR7133]

That's solved it for me - many thanks for your prompt responses

 

[scubadiver]

of course, doh!

scubadiver -

That would give the opposite of what they wanted. They said they wanted the
ones NOT paid, so the checkbox criteria should be FALSE (0) instead of TRUE
(-1).
--
Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP

Tutorials at http://www.btabdevelopment.com

__________________________________