Query Checkmarks

B

BMaerhofer

I have a question regarding a query and checkboxes.

I have a form that is used to run a report. The report is based on a query.
The problem is that I use checkboxes to define what specific to put on the
report.

Four Checkboxes:

ProjectedAccomplishment
Reoccuring
Accomplishment
ProjectedActivity

It can be a combination of the four checkboxes, one or none selected when
running the query/report. I just need to the be able to pull the specific
records based on which is true. The individual record can only be one of the
four listed above.

Thanks,
 
K

KARL DEWEY

If you check a box its value will be -1. Use that value when you formulate
your criteria.
 
Top