Prev: TransferText Error
Next: change textbox size
From: Michele E on 13 Apr 2010 09:31
I have created a report which shows a summary of the performance of all
operators in our plant. I want the report to print out with the operators
names in alphabetical order. I have this listed as SELECT [crews].ID,
[crews].Operator FROM [crews] ORDER BY [Operator]
When my reports prints though, it puts the operators in numeric oder (based
on the ID number that was orignally automatically assigned to them. How do I
change this?

Thanks!
--
Michele E
From: John Spencer on 13 Apr 2010 10:00
Reports more or less IGNORE the order by clause of a query.

You should always use the Reports Sorting and grouping to set the order of the
records. In Versions prior to 2007, open the report in design view and select
Sorting and Grouping from the View menu. There is similar functionality in
2007 (hunt for it on the ribbon).

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Michele E wrote:
> I have created a report which shows a summary of the performance of all
> operators in our plant. I want the report to print out with the operators
> names in alphabetical order. I have this listed as SELECT [crews].ID,
> [crews].Operator FROM [crews] ORDER BY [Operator]
> When my reports prints though, it puts the operators in numeric oder (based
> on the ID number that was orignally automatically assigned to them. How do I
> change this?
>
> Thanks!
From: ghetto_banjo on 13 Apr 2010 10:00
Reports in Access do not utilize the ORDER BY clause of the source
query.

Instead, you need to set it up in the Sorting & Grouping window. In
Access 2003, this can be found in the View menu (or right click in the
report to see the option appear).
From: Jerry Whittle on 13 Apr 2010 10:43
Take the sort/Order By out of the query. Reports don't use the sort order of
the query and actually resorts it. Having a sort in the query can actually
make the report slower!

Instead use the report's sorting and grouping options.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Michele E" wrote:

> I have created a report which shows a summary of the performance of all
> operators in our plant. I want the report to print out with the operators
> names in alphabetical order. I have this listed as SELECT [crews].ID,
> [crews].Operator FROM [crews] ORDER BY [Operator]
> When my reports prints though, it puts the operators in numeric oder (based
> on the ID number that was orignally automatically assigned to them. How do I
> change this?
>
> Thanks!
> --
> Michele E
From: Michele E on 16 Apr 2010 15:11
I've got this: SELECT crews.ID, crews.Operator FROM crews ORDER BY [Operator];
in my report under the properties for row source, but it still does not
work. The operators are still coming up in a random (that I can tell) order.
Any other suggestions?
--
Michele E


"Jerry Whittle" wrote:

> Take the sort/Order By out of the query. Reports don't use the sort order of
> the query and actually resorts it. Having a sort in the query can actually
> make the report slower!
>
> Instead use the report's sorting and grouping options.
> --
> Jerry Whittle, Microsoft Access MVP
> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
>
>
> "Michele E" wrote:
>
> > I have created a report which shows a summary of the performance of all
> > operators in our plant. I want the report to print out with the operators
> > names in alphabetical order. I have this listed as SELECT [crews].ID,
> > [crews].Operator FROM [crews] ORDER BY [Operator]
> > When my reports prints though, it puts the operators in numeric oder (based
> > on the ID number that was orignally automatically assigned to them. How do I
> > change this?
> >
> > Thanks!
> > --
> > Michele E
 | 
Pages: 1
Prev: TransferText Error
Next: change textbox size