L
Lostguy
Hello all.
Here is what I did:
1) Set up a query with LName, FName, DOB, BirthMonth: Month([DOB]),
and BirthDay: Day([DOB]).
2) Make a report based on this query grouped by BirthMonth and sorted
by BirthDay.
3) On the report, change the format of the BirthMonth textbox to
"mmmm".
For some reason, the first month on my report is "December" and then
ALL the other months say "January". (December, January, January,
January, January, etc.)
When I look at the query, it is correctly pulling out the month (1 for
January, 2 for February, etc.), but on the report, February and all
following months have a displayed name of "January".
Any help appreciated on how to fix this!
V/R
LostGuy
Here is what I did:
1) Set up a query with LName, FName, DOB, BirthMonth: Month([DOB]),
and BirthDay: Day([DOB]).
2) Make a report based on this query grouped by BirthMonth and sorted
by BirthDay.
3) On the report, change the format of the BirthMonth textbox to
"mmmm".
For some reason, the first month on my report is "December" and then
ALL the other months say "January". (December, January, January,
January, January, etc.)
When I look at the query, it is correctly pulling out the month (1 for
January, 2 for February, etc.), but on the report, February and all
following months have a displayed name of "January".
Any help appreciated on how to fix this!
V/R
LostGuy