sort order in report detail section

[Daniel Collison]

The detail section of a insurance claim report provides information related
to service procedure codes. Each procedure code has a Claim Status [Claim
Status 2] of 1 (allowed) or 3 (not allowed). The claim status data element
has a numeric data type (long integer).

In the detail section of the report, I want the records to sort first by
procedure code and then by claim status. Both fields in the underlying query
include a specified sort of ascending. Though the procedure code sorts
ascending in the report, the claim status control has no apparent sort order
(i.e. it shows randomly as 1, 3 or 3, 1).

Any suggestions to correct this problem would be appreciated.

 

[KARL DEWEY]

Access report ignore sorts done in a query.
In design view of the report click on VIEW - Sorting and Grouping, select
the fields and order.

 

[Daniel Collison]

SIMPLE! It took care of the problem! Daniel

Access report ignore sorts done in a query.
In design view of the report click on VIEW - Sorting and Grouping, select
the fields and order.
--
KARL DEWEY
Build a little - Test a little

The detail section of a insurance claim report provides information related
to service procedure codes. Each procedure code has a Claim Status [Claim
Status 2] of 1 (allowed) or 3 (not allowed). The claim status data element
has a numeric data type (long integer).

In the detail section of the report, I want the records to sort first by
procedure code and then by claim status. Both fields in the underlying query
include a specified sort of ascending. Though the procedure code sorts
ascending in the report, the claim status control has no apparent sort order
(i.e. it shows randomly as 1, 3 or 3, 1).

Any suggestions to correct this problem would be appreciated.