View Full Version : Calculate date in report


eugz
09-01-2004, 07:19 AM
Hi all.
I need to calculate how many records I have in each month and create table based on this summary result.
I appreciate any help.

sfreeman@co.mer
09-01-2004, 01:24 PM
Try this with a table with a field called Dates:

SELECT
Format([Dates]
,"mm" & " yyyy") AS [Date]
, Count(Format([Dates],"mm" & " yyyy"))
AS
[Count] INTO tblCountMonths
FROM
SomeData
GROUP BY
Format([Dates],"mm" & " yyyy")
ORDER BY
Format([Dates],"mm" & " yyyy"); :o

HTH