Non-alphabetized sorting in a report

[Dan]

Access2002: I am creating a simple database of contact names, locations and
phone numbers. There will be 50-60 contacts and the contacts will be in 5-6
divisions. I will need to print out contact reports sorted by division but
the listing will not be alphabetically sorted by the division name; ie; I
will need a specified, non-alphabetized sorting order. Like:
Divisions are Road, HEAT, Research, etc.

Road
name1
name2

HEAT
name3
name4

Research
name5
name6

Any help appreciated!
Thanks, Dan

 

[Ken Snell \(MVP\)]

You'll need to define a way to assign a sorting number (1, 2, 3, 4, etc.) to
each of the divisions, and then have a field in the report's recordsource
that contains the sorting number. Then you have the report sort on that
field (Sorting & Grouping window).

 

[Dan]

Thanks Ken. That's what I thought but I was hoping there was something else I
could do.
Dan

 

[Larry Linson]

There is likely some "clever coding" that could generate a sort-order from
the information you have, and sometimes that _seems_ to be such an
attractive idea. Unfortunately, it is likely to see much less attractive
when the business requirements add a new division that doesn't fit with the
"clever code". <SIGH -- been there, done that, got the t-shirt>

Larry Linson
Microsoft Access MVP

 

[Duane Hookom]

I always prefer creating a field in a table of divisions for the sorting.
However you can use a sorting and group expession like:
=Instr("Road, HEAT, Research,...", [Division)

 

[Ken Snell \(MVP\)]

Neat-o!

--

Ken Snell
<MS ACCESS MVP>

I always prefer creating a field in a table of divisions for the sorting.
However you can use a sorting and group expession like:
=Instr("Road, HEAT, Research,...", [Division)
--
Duane Hookom
Microsoft Access MVP

Access2002: I am creating a simple database of contact names, locations
and
phone numbers. There will be 50-60 contacts and the contacts will be in
5-6
divisions. I will need to print out contact reports sorted by division
but
the listing will not be alphabetically sorted by the division name; ie; I
will need a specified, non-alphabetized sorting order. Like:
Divisions are Road, HEAT, Research, etc.

Road
name1
name2

HEAT
name3
name4

Research
name5
name6

Any help appreciated!
Thanks, Dan

 

[Dan]

Thanks for all your help! I took the easy way and created a separate field.
Dan

Neat-o!

--

Ken Snell
<MS ACCESS MVP>

I always prefer creating a field in a table of divisions for the sorting.
However you can use a sorting and group expession like:
=Instr("Road, HEAT, Research,...", [Division)
--
Duane Hookom
Microsoft Access MVP

Access2002: I am creating a simple database of contact names, locations
and
phone numbers. There will be 50-60 contacts and the contacts will be in
5-6
divisions. I will need to print out contact reports sorted by division
but
the listing will not be alphabetically sorted by the division name; ie; I
will need a specified, non-alphabetized sorting order. Like:
Divisions are Road, HEAT, Research, etc.

Road
name1
name2

HEAT
name3
name4

Research
name5
name6

Any help appreciated!
Thanks, Dan