Report Showing Number of Records for Specific Date Range

[Geoffrey.Bakker]

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

 

[Marshall Barton]

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

 

[Geoffrey.Bakker]

Thanks very much!

-Geoff

Try something like:

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