how to run a report with a heading

[Janice]

I need to sort a name list in Alphabetic order and by different department.

If for the alphabetic order, I wanna show
A Ext Department
Billy 123 ABC
Cally 234 CDE

For the department order, I wanna show
ABC(maybe full name) Ext Department

I got the name list from excel and import to acess so I don't know how to do
it. I only set three different field name in the design view (name, ext and
depart) so I don't know what else should I do.

Many thanks

 

[Tim Ferguson]

I need to sort a name list in Alphabetic order and by different
department.

If for the alphabetic order, I wanna show

SELECT *
FROM MyTable
ORDER BY A

For the department order, I wanna show
ABC(maybe full name) Ext Department

SELECT *
FROM MyTable
ORDER BY Department


In the query designer, use Show Table to put the table on the top half;
then drag the fields from there into the bottom half in the order you
want to see them; then in the (i) A column or (ii) in the Department
column find the row that says Sort By and choose Ascending or Descending.

If you choose more than one column to sort by at a time, then they will
be sorted in left-to-right order, if you see what I mean.

Hope that helps


Tim F