Format Date in GroupBy query

What is the syntax for a query that will give me the Count of [PartID]
shipped each month. I think I need to do a Count on PK_ID and Group By the
DateShipped but how do I format the date. I tried using DateName but I can
only get it to work if I split out the Year and month. Thanks for the help.
The raw data looks like
PK_ID PartID DateShipped
1 KLP098A 2005-04-11 10:59:05
2 PLL907C 2005-04-12 10:43:03
3 LPK761F 2005-05-15 10:23:07

And I want the output to be
Month PartsShipped
Mar-2005 2
May-2005 1

.

Relevant Pages

  • Re: Format Date in GroupBy query
    ... >What is the syntax for a query that will give me the Count of [PartID] ... With no DDL ans sample data to go on, ...
    (microsoft.public.sqlserver.mseq)
  • Action URL
    ... I have a syntax issue. ... I can run the last line of this query in the ... MDX sample application and get results. ... Prev by Date: ...
    (microsoft.public.sqlserver.olap)
  • URL Action
    ... I have a syntax issue. ... I can run the last line of this query in the ... MDX sample application and get results. ... Prev by Date: ...
    (comp.databases.olap)
  • calling modules syntax
    ... the syntax to call my procedure from a query. ... Basically all i want is to be able to compare two numbers (contained in two ... Prev by Date: ...
    (microsoft.public.access.modulesdaovba)
  • RE: Field name truncation
    ... Syntax issue... ... Aliases can't start with a number.... ... I assume your query is going into a ... Prev by Date: ...
    (microsoft.public.access.queries)