Conditional Formating (?)

[TAWise]

In my report, I have the following fields:
Org (header) and Name, Title, Phone, Bldg/Room (detail sorted
alphabetically by Name)
For those people with the Title of "Dir" or "Mgr" or "OAA" I have set up
conditional formating for them to print in "red". However, now I have been
asked if I can move those people with the Title of "Dir" or "Mgr" or "OAA" to
the top of the listing and then sort the remaining people alphabetically by
name.

Help?

 

[Al Campagna]

TAWise,
Use an external table to provide the report a Grouping value.

Title GroupOn
Dir 1
Mgr 1
OAA 1
Emp 2
Temp 2
XYZ 2 etc.... for all other titles etc

This gives the report a value to Group on, and use sorting ascending
within the 1 and 2 group.

--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Marshall Barton]

In my report, I have the following fields:
Org (header) and Name, Title, Phone, Bldg/Room (detail sorted
alphabetically by Name)
For those people with the Title of "Dir" or "Mgr" or "OAA" I have set up
conditional formating for them to print in "red". However, now I have been
asked if I can move those people with the Title of "Dir" or "Mgr" or "OAA" to
the top of the listing and then sort the remaining people alphabetically by
name.

You can do that by inserting a new sort level above the name
level (in Sorting and Grouping). Set the new sort level's
expression to something like:

=IIf(Title IN("Dir","Mgr","OAA"), " " & Title, "zzz")

 

[TAWise]

Marsh:

I guess I need more info. What does the "zzz" represent? I get a data
mismatch when trying to open the report.

Thanx

 

[Marshall Barton]

The zzz represents three copies of the last letter in the
English alphabet (i.e. sorts after all the other letters ;-)

The point here is for the expression result to be something
that sorts the special titles before the other titles. You
can use all kinds of different characters beside a space and
zzz.

Unless your title field in the table is numeric, I have no
idea where the type mismatch is coming from.