K
Kenny
am trying to create a report based on
several variable options.
1. Team Name
2. Job Class
3. Date Range (from 1/1/2004 - 2/5/2004)
4. Report type. (% of times the team was on goal or
counts of the total queue items.
It is possible to have a form for the user to set the
above variables and create a query and/or report on the
fly?
The db consists of 3 tables.
1. with the criteria
2. Teams
3. Job Functions.
What is the best way to manipulate the numbers in the
report such as counting the number of entries and
counting only the entries which were considered on goal
so a percentage could be calculated?
several variable options.
1. Team Name
2. Job Class
3. Date Range (from 1/1/2004 - 2/5/2004)
4. Report type. (% of times the team was on goal or
counts of the total queue items.
It is possible to have a form for the user to set the
above variables and create a query and/or report on the
fly?
The db consists of 3 tables.
1. with the criteria
2. Teams
3. Job Functions.
What is the best way to manipulate the numbers in the
report such as counting the number of entries and
counting only the entries which were considered on goal
so a percentage could be calculated?