Custom Report based on user imput

[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?

 

[Duane Hookom]

You might want to check out the query by form at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. It
allows users to specify criteria, fields, grouping, etc. They can easily
send the results to Word, Excel, HTML, CSV, print, graph,...