Change Sorting in a Report

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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?
 
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...
 
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...
 
Back
Top