Re: Obtaning results per Quarters

From: Duane Hookom (duanehookom_at_NO_SPAMhotmail.com)
Date: 05/30/04 

Date: Sun, 30 May 2004 13:23:43 -0500

Are you doing this is in an MDB or an APD? If this is an MDB, you could use
a Crosstab query. Does your query contain more than one year? If it contains
more than one year, do you want to lump similar quarters together? 

-- 
Duane Hookom
MS Access MVP
"Mary" <mgfdter@hotmail.com> wrote in message
news:%23T6jx2mREHA.3016@tk2msftngp13.phx.gbl...
> Hello,
>
> Glad there someone helping out on a Sunday.
>
> I created a ranking report listing the total items sold per Salesman
> throughout the year from the most to the least.
>
>
>
> SELECT     COUNT(item_ID) AS Total, Salesman_Lastame, Salesman_ID
>
> FROM         items  INNER JOIN
>
>                       salesmen ON dbo.items.Salesman_ID =
> dbo.salesmen.Salesman_ID AND
>
>                       dbo.items.Salesman_ID = dbo.salesmen.Salesman_ID
>
> GROUP BY dbo.salesmen.Salesman_Lastname, dbo.salesman.Salesman_ID
>
>
>
>
>
> Salesman         TotalTY           1Q       2Q     3Q     4Q
>
>
> John Doe         324                  ?          ?          0          0
>
> Mary    Joe       257                  ?          ?          0          0
>
> ...
>
>
>
> Besides the total obtained, I'd like to divide the results in quarters and
> hopefully, in months.
>
> Can it be done and if so, how?
>
> Thank you in advance for the help.
>
> Mary
>
>