Posted by Simon Harris on 08/05/07 22:51

Hi,

Can anyone give me any hints as to how I can display grouped data, e.g. I
have a query that returns 20 rows, which are grouped into different areas,
i.e. One of the coumns only has 4 distinct values, where the rest are
distinct per row.

What I want to do, is display a list that prints the first of the 4
disntinct values, then the rest of the records in that group, then the 2nd
distinct value, then the records in that group...and so on. But...I only
want to display the group names once - Not for each row.

I do hope that is clear...Not the easiest of scenarios to explain!

Thank you!!

Simon.

--
--
* Please reply to group for the benefit of all
* Found the answer to your own question? Post it!
* Get a useful reply to one of your posts?...post an answer to another one
* Search first, post later : http://www.google.co.uk/groups
* Want my email address? Ask me in a post...Cos2MuchSpamMakesUFat!

[Back to original message]