sort in ascending order

[Guest]

I created a report from a query, which displayes customer names and products
they purchased. This report sorts customers by ID (primary key) in ascending
order. I want to change that to customers' last and first names in ascending
order. How I can do it without redoing the report from a scratch.

 

[Duane Hookom]

Open the sorting and grouping dialog in the report design view and change
the fields as appropriate.

 

[Larry Linson]

I created a report from a query, which
displayes customer names and products
they purchased. This report sorts customers
by ID (primary key) in ascending order. I
want to change that to customers' last and
first names in ascending order. How I can
do it without redoing the report from
a scratch.

Depending on your data and details of your Report implementation, it may be
as simple as opening the Report in design view, right-clicking on the
upper-left-most little square, choosing "Sorting and Grouping" and setting
those Fields for Sorting.

Reports' Sorting and Grouping properties are the only reliable way to sort
(and group) in Reports. The order of the information in the Record Source is
immaterial.

Larry Linson
Microsoft Access MVP

 

[Guest]

it worked, thank you

Depending on your data and details of your Report implementation, it may be
as simple as opening the Report in design view, right-clicking on the
upper-left-most little square, choosing "Sorting and Grouping" and setting
those Fields for Sorting.

Reports' Sorting and Grouping properties are the only reliable way to sort
(and group) in Reports. The order of the information in the Record Source is
immaterial.

Larry Linson
Microsoft Access MVP