Hi :
What I need to ahieve is prety easy and my code works to some extend but not precisly!
It only retrieves the first row of the desired group!
I'd like to group my out put so an example would be:
Schools:
ABC School
123 School
Londn High
Universities:
McGill
York
Yale
etc....
I'm using this code:
Select * FROM Business Group BY Category Having Alphabet = '$Alpha'
It does output in groups, but as I said earlier only the first row of each section, for example:
Schools:
ABC School
Universities:
McGill
Your help is greatly appreciated!
kamy
