Report Showing Number of Records for Specific Date Range

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Geoffrey.Bakker@gmail.com - 16 Jan 2007 19:02 GMT

I have a database which records Presentations based on PresentationDate
as a date in format DDMMYYYY and PresentationSemester (Spring, Summer,
Fall). I need my report to display the number of presentations done
for each semester in each year. Is this possible in access? I have
tried the count function but that just counts the total number of
presentations not a subgroup count. Thanks

Reply to this Message

Marshall Barton - 16 Jan 2007 20:52 GMT

>I have a database which records Presentations based on PresentationDate
>as a date in format DDMMYYYY and PresentationSemester (Spring, Summer,
>Fall). I need my report to display the number of presentations done
>for each semester in each year. Is this possible in access? I have
>tried the count function but that just counts the total number of
>presentations not a subgroup count. Thanks

Try something like:

SELECT Year(PresentationDate),
                PresentationSemester,
                Count(*) As PresentationCount
FROM sometable
GROUP BY Year(PresentationDate),
                                PresentationSemester

Signature

Marsh
MVP [MS Access]

Reply to this Message

Geoffrey.Bakker@gmail.com - 18 Jan 2007 16:38 GMT

Thanks very much!

-Geoff

> >I have a database which records Presentations based on PresentationDate
> >as a date in format DDMMYYYY and PresentationSemester (Spring, Summer,
[quoted text clipped - 11 lines]
> GROUP BY Year(PresentationDate),
> PresentationSemester

Reply to this Message