Change Sorting in a Report

G

Guest

I have a report that is sorted by Month, and it is sorting alphabetically,
how do I get it to sort by month starting with January? I have sorted it by
month in the table and it starts with January, but for some reason when I do
the report it is sorting alphabetically. Please Help.

Thanks
 
R

Rick B

No, what is in the Sorting and Grouping box in your report's design view?
How are you telling it to sort by "month"? You don't actually have a field
with the month in it, do you? You are doing something like...

=Month([SomeDateField])

right?
 
G

Guest

I actually created the report off a query, and in the query I have a field
with totals, and I did a summary of the totals and then it asked me how I
wanted them sorted and I selected by Month. Is this where I am having the
problem?

Rick B said:
No, what is in the Sorting and Grouping box in your report's design view?
How are you telling it to sort by "month"? You don't actually have a field
with the month in it, do you? You are doing something like...

=Month([SomeDateField])

right?


--
Rick B



Jenn Civello said:
It is Ascending
Click to expand...
Click to expand...
 
R

Rick B

Don't know. You need to set your sorting in the report, which will override
how your query is sorted. Use the sorting and groping box.



--
Rick B



Jenn Civello said:
I actually created the report off a query, and in the query I have a field
with totals, and I did a summary of the totals and then it asked me how I
wanted them sorted and I selected by Month. Is this where I am having the
problem?

Rick B said:
No, what is in the Sorting and Grouping box in your report's design view?
How are you telling it to sort by "month"? You don't actually have a field
with the month in it, do you? You are doing something like...

=Month([SomeDateField])

right?


--
Rick B



Jenn Civello said:
It is Ascending

:

What is currently in your "sort" box?

--
Rick B



I have a report that is sorted by Month, and it is sorting alphabetically,
how do I get it to sort by month starting with January? I have
Click to expand...
sorted
it
by
month in the table and it starts with January, but for some reason when I
do
the report it is sorting alphabetically. Please Help.

Thanks
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting an Access report by month 5
sort chronologically when summing by month 2
need help sorting text by trailing Numbers Value 9
ACC2000 Month-Year sort in charts 1
concatenated field in a report is not sorted 1
Sorting a date field 7
Sort a group 3
Sorting Reports & Combining categories 3

Top