Thank you very much. I changed it to be just what you wrote and it did
impact my report but now I get the months to print out as a primary
grouping/heading level but January 1944 is first with all january 1944
bdays,
then March 1945 with every record with birthdates then, then January 1950
and
so on. So the year is still impacting the sort. I hoped to be able to
get
JANUARY as the heading/grouping and ALL JANUARY birthdates under it. Then
FEBRUARY and all February bdays regardless of year under that, etc. SO
there
would be 12 groupings. My report now has 50+ groupings because each
month/year combo is its own grouping.
It seems to me that there should be an easy way to fix this but I have
fiddled with it for hours and can't get it!
HELP!!
THanks,
wendy
Duane Hookom said:
In the report's sorting and grouping dialog. This is where all report
sorting should be defined.
--
Duane Hookom
MS Access MVP
dwae2000 said:
Where do I write that info? In the field's properties section?
Thanks so much for all of your help.
Wendy
:
Set the report's primary sorting and grouping level to an expression
like:
=Format([DOB],"mmdd")
--
Duane Hookom
MS Access MVP
--
I have an address book database with a field titled "DOB". I would
like
to
be able to create a report (but assume I must do a query first) to
get
a
listing in order by date - month and day. I want the list to list
January
1st bdays before January 2 bdays, etc - regardless of the year. Is
this
possible?
Thanks so much.
Wendy
