different sort help

S

Steiner

all i want to do is custom sort one of my columns is the only way
that i can do that with SQL or can i do it another way. I need my columns
to be sorted a particulyr way as on the report the order need to be
consistent please help
 
A

Allen Browne

The sorting in a report is defined by the Sorting And Grouping dialog, not
the sort order in its source table/query.

1. Open your report in design view.

2. Open the Sorting And Grouping dialog (View menu).

3. Specify the field that the report should sort by there.
 
V

Van T. Dinh

If you use the Query as the RecordSource of the Report, don't sort the
Records in the Query as the Report will *ignore* the sorting in the Query.

You need to use the Sorting & Grouping of the Report which you can access
using the Menu View / Sorting & Grouping ...

Check you Access books / Access Help on Sorting & Grouping of a Report.
 
Top