Non-alphabetized sorting in a report

D

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
 
K

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).
 
D

Dan

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

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
 
D

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)
 
K

Ken Snell \(MVP\)

Neat-o!

--

Ken Snell
<MS ACCESS MVP>

Duane Hookom said:
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


Dan said:
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
 
D

Dan

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

Ken Snell (MVP) said:
Neat-o!

--

Ken Snell
<MS ACCESS MVP>

Duane Hookom said:
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


Dan said:
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
 

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

Top