Sort by Date

[Guest]

I have a report that groups information by date by month I would like the
report to have the information in chronological order. January, February
etc... but it sorts the month alphabetically. What can I do to make this
work please? Thanks

 

[Rick B]

How are you doing your sort?

If you enter the following in your sorting and grouping, I believe it will
sort numerically...

=Month([YourDateFieldHere])

 

[Guest]

Thanks works great! Don't know why I try and make it so hard.

How are you doing your sort?

If you enter the following in your sorting and grouping, I believe it will
sort numerically...

=Month([YourDateFieldHere])

--
Rick B

I have a report that groups information by date by month I would like the
report to have the information in chronological order. January, February
etc... but it sorts the month alphabetically. What can I do to make this
work please? Thanks

 

[Pat Hartman\(MVP\)]

It probably wasn't working originally because you formatted the date in the
query instead of in the report. When you Format a date, you change it from
a double precision number to a text string. A string date will ONLY sort
properly if it is in the format yyyy/mm/dd

 

[Guest]

Hello Rick,

Where do I put =Month([YourDateFieldHere])? I have tried numerous places
without success!

My report is built from a query that was set up to show the sum of each
month (and the months are displayed alphabetically, not cronologically like I
want). Any further help would be greatly appreciated! Thanks in advance.

Joe

How are you doing your sort?

If you enter the following in your sorting and grouping, I believe it will
sort numerically...

=Month([YourDateFieldHere])

--
Rick B

I have a report that groups information by date by month I would like the
report to have the information in chronological order. January, February
etc... but it sorts the month alphabetically. What can I do to make this
work please? Thanks

 

[fredg]

Hello Rick,

Where do I put =Month([YourDateFieldHere])? I have tried numerous places
without success!

My report is built from a query that was set up to show the sum of each
month (and the months are displayed alphabetically, not cronologically like I
want). Any further help would be greatly appreciated! Thanks in advance.

Joe

How are you doing your sort?

If you enter the following in your sorting and grouping, I believe it will
sort numerically...

=Month([YourDateFieldHere])

--
Rick B

I have a report that groups information by date by month I would like the
report to have the information in chronological order. January, February
etc... but it sorts the month alphabetically. What can I do to make this
work please? Thanks

You need to sort a report in the report's Sorting and Grouping dialog.

In Report Design View, click on View + Sorting and Grouping.

As the first entry on the Field/Expression line, write
=Month([YourDateFieldHere])

Enter Ascending in the right hand column.
If you also wish to group the report on the Month, select Group Header
= Yes in the lower panel.
Note: your expression will sort on all January's, February's, etc.
regardless of the year. Is that what you want?

 

[Guest]

Thanks Fred, worked like a charm! I just put =Year([YourDateFieldHere]),
Ascending then =Month([YourDateFieldHere]), Ascending and it gave me what I
wanted. May just be an okay Monday after all! Thanks again!!

Joe

Hello Rick,

Where do I put =Month([YourDateFieldHere])? I have tried numerous places
without success!

My report is built from a query that was set up to show the sum of each
month (and the months are displayed alphabetically, not cronologically like I
want). Any further help would be greatly appreciated! Thanks in advance.

Joe

How are you doing your sort?

If you enter the following in your sorting and grouping, I believe it will
sort numerically...

=Month([YourDateFieldHere])

--
Rick B

I have a report that groups information by date by month I would like the
report to have the information in chronological order. January, February
etc... but it sorts the month alphabetically. What can I do to make this
work please? Thanks

You need to sort a report in the report's Sorting and Grouping dialog.

In Report Design View, click on View + Sorting and Grouping.

As the first entry on the Field/Expression line, write
=Month([YourDateFieldHere])

Enter Ascending in the right hand column.
If you also wish to group the report on the Month, select Group Header
= Yes in the lower panel.
Note: your expression will sort on all January's, February's, etc.
regardless of the year. Is that what you want?