Query Checkmarks

  • Thread starter Thread starter BMaerhofer
  • Start date Start date
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,
 
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

open report if... 2
Filter query with checkboxes 0
question driven query 6
Union query - using VBA? 6
Combine Duplicates in Query 0
Using Checkbox as Multi-Selection in Form Query 4
IIF function 2
Checkboxes and Query Criteria 1

Back
Top