select fields at run-time

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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.
 
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
 
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!
 
Back
Top