I am trying to design a form in (Ms Access) which will provide my users multiple reporting options using the same query.

my query contains the following fields:

Daycode
WeekNumber
PeriodNumber
Line
Machine
Eventcode
TotalTime
Occur
Avg

i want the user to choose in this order :

a time period to run the report.....either Daycode, WeekNumber,PeriodNumber

then select:

a Line,

then select either Totaltime, Occur or Avg (this will require to be sorted Desecnding..

then finally to decide wheter to have all the data remaining, or sorted by machine. So effectivly i want to be able to switch between various show fields of my query

DB is here--------> http://www.utteraccess.com/forums/download.php?Number=537339]Click Here[/URL]