queries

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

Guest

I have done a query on some date and have it sorted down to a specific year
and acsending in months but i need to sort the data by individual months any
help


Dale
 
You stated the query is "sorted down to a specific year and acsending in
months" and then ask how to "sort the data by individual months". Can you be
any more specific? Maybe provide some sample records and how you want them
to sort.

--
Duane Hookom
MS Access MVP


"separating individual months" <separating individual months
@discussions.microsoft.com> wrote in message
news:[email protected]...
 
I have jan, feb, mar orders all separated by the month but i need to break
them up by month to get information out of them by month ie number of hours
per client by month
 
Apparently you didn't understand what I meant by providing some sample
records and how you want them to sort.

Duane Hookom
MS Access MVP
 
sorry i am new to this how do I show you a sample

order_date cust_id
6/20/2002 47
6/21/2002 48
6/21/2002 59
7/1/2002 24
7/1/2002 26
7/1/2002 37
7/1/2002 14
7/3/2002 16
7/3/2002 24
7/9/2002 27
7/9/2002 41
7/9/2002 42
7/9/2002 46
7/9/2002 45
7/9/2002 49
7/9/2002 36
7/18/2002 2
8/1/2002 1
8/1/2002 4
8/1/2002 6
8/1/2002 5
8/1/2002 29
now i want a count of the individual months separate. So how many times
there is aenrty in june july and August
 
Select Month(Order_Date) as Mth, Count(Cust_ID) as NumOf
FROM tblOrders
GROUP BY Month(Order_Date);
 
Back
Top