date parameters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?
 
Back
Top