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.

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" <(E-Mail Removed)> wrote in message
news:8B4588AE-0AD5-4695-B84D-(E-Mail Removed)...
>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.

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" <(E-Mail Removed)> wrote in message
news:8B4588AE-0AD5-4695-B84D-(E-Mail Removed)...
>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.

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

Ah! That's the one I was trying to think of. Tidier than DateSerial.

"fredg" <(E-Mail Removed)> wrote in message
news:16i2fi2zot1jz$.(E-Mail Removed)...
> 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