queries

  • Thread starter separating individual months
  • Start date
S

separating individual months

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
 
D

Duane Hookom

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]...
 
D

Dale Walker

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
 
D

Duane Hookom

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
 
D

Dale Walker

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
 
D

Duane Hookom

Select Month(Order_Date) as Mth, Count(Cust_ID) as NumOf
FROM tblOrders
GROUP BY Month(Order_Date);
 
Top