group by date

[Rodolfo Fontes]

Hi group,

I have the following query, that list to me all events that has ocurried
between a date.
The first collun list the date, the second lists the event, and the third is
a count of events by that date.
I want to create a graphic that list the count of events by month.
Do I have to change this query, or can i just set something on the graph?

THE SQL is:

SELECT [T NF_S].DT_Emissao, [T NF_S_Det].[Part#F], Count([T
NF_S_Det].Qtd_NF) AS ContarDeQtd_NF
FROM [T NF_S] INNER JOIN [T NF_S_Det] ON [T NF_S].Cod_NF_S = [T
NF_S_Det].Cod_NF_S
GROUP BY [T NF_S].DT_Emissao, [T NF_S_Det].[Part#F]
HAVING ((([T NF_S].DT_Emissao)>=#1/1/2004# And ([T
NF_S].DT_Emissao)<=#12/31/2004#))
ORDER BY [T NF_S].DT_Emissao;

Tks,
Rodolfo Fontes