Using parameter query and finding totals

M

M. Britt

I am new to Access to bear with me...

I have a database of exercise types (bike, walk etc.) and amount (total
miles or min) and the date the exercise was done. What I want to do is create
a parameter query (that's the easy part...) to specify a total between
certain time periods, but all I get is a list from each day.
For example (date parameters 5/5/05-5/9/05), exercise criteria (walk),
amount (sum) This is how it shows when I run the query
5/5/05 5.0
5/6/05 2.25
5/7/05 3
5/8/05 1
5/9/05 4

It totals each record set, but I want the totals for walking between these
dates...
total amount: 15.25

How do I ask this in a query?
M. Britt
 
G

George Nicholson

In the query design window:
- Uncheck the "Show" box under the Date field
- If the "Totals" line is showing, the Date field should be classified as
"Where", not "Group By"

If you use the SQL window of query design the Date field should only appear
as part of the Where clause.

HTH,
 
Top