Orders

[Johnny26652]

Hello
I have a orders table. i am trying to query orders with in 30 days after shipped date? how can i do it?

orderid
orderdate
shippeddate
orderreason


say for eg: i shipped a order on 10/01/2006 and i am trying to find orders between 10/01/2006 and 10/31/2006

I want to count number of orders between these dates.

and also in a different query i want to find all the orderreasons between those dates?

help please.

thanks
Johnny

[rdivilbiss]

SELECT Count(orders.orderid) AS OrderCount FROM orders WHERE ((orders.orderdate) Between #10/1/2006# And #10/31/2006#);

SELECT orders.orderreason, Count(orders.orderreason) AS ReasonCount FROM orders WHERE ((orders.orderdate) Between #10/1/2006# And #10/31/2006#) GROUP BY orders.orderreason
ORDER BY Count(orders.orderreason) DESC;

http://www.w3schools.com/sql/sql_between.asp