criteria

[stefanie]

I've made an orderprocessingsystem in Access. This
contains the tables orders, detail of orders and products.
I'm making a querie with which you can search for the
total revenues in a certain period.
I have the following columns: product-ID, name of product,
total revenues and date when ordered.
the total revenues colums is a sum calculation
For criteria have I got certain parameters that need to be
given:
give product ID
give product name give earliest date give latest date

the querie does select on these criteria, but when I run
it, it gives all data instead of the sum, I've checked.
When i delete the column date when ordered, the querie
does as asked

does anyone know how to solve this?

thanx

 

[Kelvin]

Set the group option for the dats to Where instead of Group By.

Kelvin