Hello Everyone,

I need you help.

I want to do a report which shows the total student enrolled number of each month, and it bases on the student enrolled date. But on the enrolled date field, I set up the format is mm/dd/yyyy which I have to(I use calendar).

So, how can I do the number of student enrolled by month on query and show on the report?

Thanks,
Cindy

If it is a data field then you should not be storing it formatted as text). If stored as a date/time data type then tt is a number without any date formatting. This allows your to format the date as needed when you display it.

I will assume that the enrollment date field is properly stored as date/time data type.


What I do is create a calculated field something like this:

EnrolledYYYYMM: Format([enrolled_date],"YYYYMM)

Now you can group on the feuild and get yuour count for teh primary key feild.

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015

Thanks, I will create another field to catch the month.

Cindy

Just to be clear, I am not recommending adding a field to the table but a calculated field in the query only. The data will not be3 stored. Only calculated as needed.

I would include the year with the month. This will allow it to sort better. is the data range is over 12 months and/or span multiple calendar years

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015