Report only select items?

C

ctB

I have a database of items. One of the entries is a check box. I'd
like to have a report of the items showing ONLY the entries with that
box checked, and also a report showing items that do NOT have the
box checked. Can this be done?

Thanks!

Chris
 
M

Marshall Barton

ctB said:
I have a database of items. One of the entries is a check box. I'd
like to have a report of the items showing ONLY the entries with that
box checked, and also a report showing items that do NOT have the
box checked. Can this be done?


A quick an dirty way to do that is to use a query as the
report's record source. In the query use a criteria like:

CBoo([Enter True or False])

for the Yes/No field
 
C

ctB

Marshall said:
ctB said:
I have a database of items. One of the entries is a check box. I'd
like to have a report of the items showing ONLY the entries with that
box checked, and also a report showing items that do NOT have the
box checked. Can this be done?


A quick an dirty way to do that is to use a query as the
report's record source. In the query use a criteria like:

CBoo([Enter True or False])

for the Yes/No field

That did the trick! Thanks very much.

Chris
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top