not assending OR descending... how...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I need to get some help with how to sort a report item. It is not assending
or descending. I need it in a specific order. I'm at a loss.

Project #0014 Johnson House
Phase: EC, MP, CP, SD, DD, CD, PB, CA, AD

They need to be in that order. The rest of my report is perfect. I have
everything sorting and summing exactly where I want it.

Any suggestions would be greatly appreciated. Please keep it simple, my
knowledge of Access is very novice. Thanks so much.

:-)
LisaB.
 
RusCat said:
Hello,

I need to get some help with how to sort a report item. It is not assending
or descending. I need it in a specific order. I'm at a loss.

Project #0014 Johnson House
Phase: EC, MP, CP, SD, DD, CD, PB, CA, AD

They need to be in that order. The rest of my report is perfect. I have
everything sorting and summing exactly where I want it.

Any suggestions would be greatly appreciated. Please keep it simple, my
knowledge of Access is very novice. Thanks so much.
Click to expand...

Create a small table with two fields one Text and one Numeric. Make an
entry for each text value above and then assign a numeric value that will
put it in the desired sort position. Include this table in your report's
query and sort on the numeric field.
 
Back
Top