Author: funluckykitty | Posted on: 8/18/2008 8:18:29 AM | Views : 518

I have a query that returns a list of employees, and the office they work in.  Instead of listing the employees in alphabetical order, I need to list them in alphabetical order by Office.  How do I "filter thru" my list and display employees grouped by office, wiithout doing separate queries for each office?  Here's what I need to do

Chicago
   Employee1
   Employee2
   Employee3

New York
  Employee 4
  Employee 5

Washington D.C.
  Employee 6
  Employee 7

 All I can get my list to do is list employee 1-7 and their office name beside the employee name.  I don't know how to do this grouping...

...

Go to the complete details ...