cross-tab querie

[billy]

Thank you for taking the time to read and respond to my
question, I appreciate it.

I have a cross-tab querie who has "baseball", basketball,
football, and soccer, as row heading and "student ID" as
the column heading. I have the total(sum) of all hours
spend per each sport listed.

I would like to setup a multiple parameter querie that
displays inputs that were placed between two dates, hence
what I would like to do is to prompt the user for two
dates, and the querie would show the sum of the hours
spent in each of the sports during the date inputted.

I setup [start date] and [end date] in the parameter menu
but when I run the querie, it shows the total hours
inputted and not the total hours between the two dates.
thankd again

 

[Duane Hookom]

You must also place "Between [Start Date] And [End Date]" in the criteria.
Set the Totals value to "Where".