grouping on reports 1

[jpl458]

I have a contact list I want to email out of ACCESS 2003. The list is in an employee table on SQL Server 2005 The problem is in the formatting of the report. I have the report grouped by position, such as Manager, Asst Mgr, Supervisor, Asst Supvr, etc. I want to have the Manager at the top of the report followed by the Asst Mger, then the supervisors etc. Obviously sorting the groups doesn't work.

Any suggestions?

jpl

 

[dhookom]

I expect you have a table positions. Add a field that identifies the sorting so you can use it in the report.

BTW: when asking report questions, you should use the Access Reports forum.

Duane
Hook'D on Access
MS Access MVP

 

[jpl458]

Unfortunately I can't add a field to the server, thought of that. Thought there might be a another way. Sorry for posting here, will ask again on the reports forum. Thanks for the help.

jpl