sort in ascending order

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Open the sorting and grouping dialog in the report design view and change
the fields as appropriate.
 
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.
Click to expand...

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
 
it worked, thank you

Larry Linson said:
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
Click to expand...
 
Back
Top