Suppressing Repeating Groups in a Query

[sam komolafe]

Hi guys,

How do you suppress repeating groups in a query? e.g.

What I Have:
1    DN12    California        
1    DN12    Oregon
5    DQ46    Utah
5    DQ46    New York
9    DZ09     Texas

What I Want:
1    DN12    California        
                    Oregon
5    DQ46     Utah
                     Utah
9    DZ09      Texas

Thanks

------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]