Create queries based on form selections

[dreamsoul620]

Hi,
I'm creating an attendance tracking database. I have my main form that
allows the user to select what kind of report they wish to view on the
attendance. How can I create a query that will yield the different
combinations of results?
Example: The user might want to see a report on employees that have 10 or
more points against them (all these are radio button selections), through
dates 1/01 - 2/01, sorted by department. They could also choose to see
employees with absences for the past week, sorted by shift. The dates are
either entered in in predefined format or just for the past week. There is
also an option so that the user can select a summary report or full detail
report. Basically, a few fields will be missing to make the reports shorter.


Any ideas are greatly appreciated.
Thanks.

 

[Brian Bastl]

You may want to bookmark this useful site:

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

Download "DH Query By Form". I think that'll be what you're looking for.

Brian

 

[dreamsoul620 via AccessMonster.com]

Thanks. That helps a little, but I'm not sure I want to give the user that
much control. Is there a way to create parameter queries and allow the
choices in the option groups to be the parameters? This would allow the
user to click the Preview Report button and the query automatically run in
the background based on the choices.