different sort help

[Guest]

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

 

[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.

 

[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.