date parameters

C

carolm

H

I have a query written that is like thi

Store Name Store No GMT No Coast/Oasi
Total Group By Group By Count Group B
Sort Descendin

When i run the query it gives something like

Covent Garden 8104 2
Argyll St 9754 2

What i would like to do is be able to query between two dates eg, 1st May to 6th May. When i enter a date paremeter the query runs but would look like thi

1/5 Covent 8104
1/5 Argyll 9754
2/5 Covent 8104
2/5 Argyll 9754

I would like the query to look the same as the first without separating it by date order. Is this possible?

Thanks in advanc

Carol
 
L

Les

In the total area for the date parameters, change it
to "Where". I think you have it set to Group BY.
-----Original Message-----
Hi

I have a query written that is like this

Store Name Store
Click to expand...
No GMT No Coast/Oasis
Total Group By Group
Click to expand...
By Count Group By
Sort Descending

When i run the query it gives something like.

Covent Garden 8104 25
Argyll St 9754 20

What i would like to do is be able to query between two
Click to expand...
dates eg, 1st May to 6th May. When i enter a date
paremeter the query runs but would look like this
1/5 Covent 8104 1
1/5 Argyll 9754 2
2/5 Covent 8104 4
2/5 Argyll 9754 1

I would like the query to look the same as the first
Click to expand...
without separating it by date order. Is this possible?
 
Top