sorting by dates

[Guest]

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

 

[Duane Hookom]

Set the report's primary sorting and grouping level to an expression like:

=Format([DOB],"mmdd")

 

[Guest]

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

 

[Duane Hookom]

In the report's sorting and grouping dialog. This is where all report
sorting should be defined.

--
Duane Hookom
MS Access MVP

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

 

[Guest]

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

In the report's sorting and grouping dialog. This is where all report
sorting should be defined.

--
Duane Hookom
MS Access MVP

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

 

[Duane Hookom]

I think you have entered something wrong. What is the expression in your
sorting and grouping level(s)?

--
Duane Hookom
MS Access MVP

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

In the report's sorting and grouping dialog. This is where all report
sorting should be defined.

--
Duane Hookom
MS Access MVP

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

 

[John Vinson]

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!

Put a calculated field in your query:

Format([DateOfBirth[, "mmmm")

Use this field for the grouping. It will contain *ONLY* the month
name.

John W. Vinson[MVP]