Calculate how many times

[krh]

Hello!

I need to find out how many times someone attended in a month and year. something like:

IF(Month(ADate="4");Count(Adate)

It counts Adate, but all of them.

How do I get only the month of april?

Thanks in advanced!

Edited October 6, 2010 by Guest
removed shouting from the title

[Vaughan]

Create a calc field to calculate the year and month:

Year( ADate ) & " " & Month( ADate )

You need the year as well so April 2009 attendances aren't counted along with April 2010 and 2011.

Then make a summary report using this field as the sub-summary.

To get only the month of April, perform a find in ADate field before running the report.

[LaRetta]

I prefer turning the dates into generic date (first day of month date calc), learned from Comment as:

Date - Day ( Date ) + 1

There are many reasons:

• Because it is a date, it can be used in many other date calculations
• The same field can be used for many things, such as range relationships.
• When printing reports, that date field can be used in the leading part (and displayed only as September, 2009)
• Searching on the field is just as easy as searching a regular date (because it IS a regular date), such as 2009 will find all for the year, 9/2009 will find September 2009 etc

Whenever I've added this date to a table, I've ended up using it (and was glad it was there) for many other things.