Okay, here is what I need/want to do...

Not only sort by group, I want to break it down to display in sections...

Displayed like this:

Group1
  Item 1
  Item 2
  Item 3
 
Group2
  Item 4
  Item 5
  Item 6
 
Group 3
  Item 7
  Item 8
  Item 9
etc.

Can this be done with one server call? I believe I need to use GROUP BY but can't figure out how to make it work to display the info in sections like this.

any ideas..?

Thanks all,

Chip

Hmm I think you might be looking at this wrong.

You probably don't need to grab all the information within a single SQL query.

Show us the exact information you are looking to display like that, you should be able to do even 3 SQL queries to pull the info.

Also it's hard for us to give you code if we don't know the table names and fields.

I know that I can do 3 seperate runs to the server for this, however, for this to be truly dynamic, for instance, what if I do not know what values are in the group field. At any given time there may be 3 or 7 or more vaules in this field. If I want to display all records for each of these values, it needs to be produced on the fly...