If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Birthday list by month
I have grouped my report my month but it also separates by year. I would like
a report of birthdays by month regardless of they year of birth. Is that possible? Thanks. |
#2
|
|||
|
|||
Birthday list by month
Soyful,
Use the Month(YourDate) to assign a value to every record (1-12). Then group your report on that value. -- hth Al Campagna Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "Soyful" wrote in message ... I have grouped my report my month but it also separates by year. I would like a report of birthdays by month regardless of they year of birth. Is that possible? Thanks. |
#3
|
|||
|
|||
Birthday list by month
One way is to use this as the Grouping expression in the report:
=DateSerial(Year(Date()),Month([BirthDate]),1) I would use a group header. In the header put a text box bound to BirthDate, formatted as mmmm. Force a new page before the section (on the group header property sheet). These are formatting choices that will not affect the basic idea one way or the other. "Soyful" wrote in message ... I have grouped my report my month but it also separates by year. I would like a report of birthdays by month regardless of they year of birth. Is that possible? Thanks. |
#4
|
|||
|
|||
Birthday list by month
On Fri, 31 Oct 2008 09:33:00 -0700, Soyful wrote:
I have grouped my report my month but it also separates by year. I would like a report of birthdays by month regardless of they year of birth. Is that possible? Thanks. Group it by month instead of month and year. In Report Design View. click on View + Sorting and Grouping In the Report's Sorting and Grouping dialog: Field/Expression Sort =Month([DateOfBirth]) Ascending -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#5
|
|||
|
|||
Birthday list by month
Ah! That's the one I was trying to think of. Tidier than DateSerial.
"fredg" wrote in message ... On Fri, 31 Oct 2008 09:33:00 -0700, Soyful wrote: I have grouped my report my month but it also separates by year. I would like a report of birthdays by month regardless of they year of birth. Is that possible? Thanks. Group it by month instead of month and year. In Report Design View. click on View + Sorting and Grouping In the Report's Sorting and Grouping dialog: Field/Expression Sort =Month([DateOfBirth]) Ascending -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
Thread Tools | |
Display Modes | |
|
|