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
No GMT No Coast/Oasis
Total Group By Group
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
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
without separating it by date order. Is this possible?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Referencing Data 1
The query cannot be completed. 1
Text to Date 4
Date ranges 5
End of Month: Parameter Query? 3
Query Problem 13
wrting query to get result 1
SQL Question 1

Back
Top