Change Sorting in a Report

J

Jenn Civello

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?
 
J

Jenn Civello

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...
 
Top