Sort report same as underlying table/query

[Dawnit]

Hello! I have an Access 2000 table or query that is NOT sorted ascending or descending, which is what I want. The table or query is the data source for a report that must reflect the record order as defined in the table or query. My report settings are as follows:

sorting and grouping: field 1, ascending
Order by on: yes
Order by:

.field 2

Ultimately, I want the report to list records as they are listed in the underlying table or query.

Thanks very much!