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.
 

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

Similar Threads

question driven query 6
open report if... 2
Checkboxes and Query Criteria 1
Query from Multiple Checkboxes 1
Show select table entries based on yes/no checkbox answers 1
Null Parameters 1
count two check box fields 2
Checkboxes that return zero are counted as 1 in my report 1

Top