select fields at run-time

[Guest]

Is there a way to run a query & at run-time have the user select what needs
to be included? I have "inherited" a database that has monthly, quarterly,
etc. tasks listed, and there is a column for each month (yes/no) that marks
when a task must be completed. (I know that is not the best way to have this
set-up, but there is a rather large number of records & I don't want to try
to redesign it.) Basically, I am suppose to run a report every month that
shows everyone in the department what they have to do, & I just want to be
able to set up 1 query & 1 report instead of 1 for every month.

Thanks ahead for any help!

 

[[MVP] S.Clark]

Pretty much no matter what you do, you're going to need some code(VBA
preferably) to make it happen. The fact that you're in checkbox Hell
exacerbates the situation.

 

[Guest]

Since I frequently use check boxes to indicated that something has, or has
not, happened this post caudht my attention. What exactly is "checkbox
hell?" How would you redesigh out checkboxes?

Steve

 

[Guest]

Okay--that is what I needed to know. I am a little rusty at this, so I
couldn't remember if access had a (quick) work around. Now off to write my
code.....

Thanks!