access 2003 "sort" groups 1

[jpl458]

Have an employee table that i want to email out of access. Created report and grouped data by "Position" column in table. Positions are Manager, Asst Mgr, Supervisor, Asst Spvsr, etc. But, I can't figure out how to get the groups to be in the proper order on the report,"Manager" at the top, followed By "Asst Mger", then Supervisor. Sorting ascending or descending is no help. Not allowed to add field to the table.

I asked this same question on the Forms forum by mistake.

Any suggestions?

Thanks in advance

jpl

 

[dhookom]

Hi again. You can set the sorting and grouping to an expression including a function name. A sample expression might be:

=Instr("Manager, Asst Mgr, Supervisor, Asst Spvsr",[Position])

A small user-defined function might be easier to maintain.

Duane
Hook'D on Access
MS Access MVP

 

[jpl458]

Thanks Duane, I'll give that a go. I found a column that was empty and just stuck in a number that I could sort on. But I don't like that solution because the column name does not describe the data I inserted. Worried that some time in the future someone else will put real data in that column and I, and my Roster, be screwed.

I'll give this a try. Much cleaner

Thanks again for the help.

jpl