Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chimp
Starting Member
3 Posts |
 Posted - 2004-09-09 : 04:31:53
|
| I am trying to design a form which will provide my users multiple reporting options using the same query.my query contains the following fields:DaycodeWeekNumberPeriodNumberLineMachineEventcodeTotalTimeOccurAvgi want the user to choose in this order :a time period to run the report.....either Daycode, WeekNumber,PeriodNumberthen 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.DB is here--------> [url]http://www.utteraccess.com/forums/download.php?Number=537339[/url] |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2004-09-09 : 07:54:10
|
| Great, thanks for letting us know.- Jeff |
 |
|
|
chimp
Starting Member
3 Posts |
Posted - 2004-09-10 : 04:12:55
|
| ok, as we now have 2 clowns in the house... :) ....the biggest being me for failing to explain where i am struggling.i am led to understand that this could be written through SQL, is this the case ? if so any pointers as to where i could start please.Andy |
|
|
|
|
|
|
Multiple Filters on a form