Soring in a Report

J

JS

I have a report creating that has a field [cboComplexityCode]. The field is
a lookup with the values of HCK, LCK, MCK, HC, LC, MC.

When I run the report I need this field to sort but not in descending or
ascending order but by the sample below:

-----------------------------

Jane Doe For the Month Of November 2006

LCK 200
HCK 100
MCK 500

then a blank line with

LC 20
HC 30
MC 40

The way it is sorted now is:

HCK
HC
LCK
LC
MCK
MC

Is there a way to change this sort. I know very little Visual Basic.
Thanks for any help you can provide.

JS
 
R

Rick B

One way is to add a "sort" field to the table that stores the complexity
codes. If you have those stored in a separate table, just add a sort field
to it and use that in your query/report.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting Up Report 3
Sorting text field value in a report 4
Crosstab rows sort order 4
Result summary in a report 1
Sorting by complex alphanumeric data 8
Dates not sorting correctly in Report 9
Sorting records in the Report Design View 1
Portfolio type report in Access 0

Top