[dba-VB] VB6 Crosstab Query Help

To all,
 
I have a crosstab query in an Access application that I would like to take across into my VB6 application, having never tried this before I would firstly like to know if it is possible & how to go about it and secondly how would I display the data in crosstab format.
 
Any sample code etc greatly appreciated.
 
Thanks in advance to anyone that can help on this matter.
 
Paul Hartland
Database Designer/Developer.
Freeserve AnyTime - HALF PRICE for the first 3 months - Save £7.50 a month 
www.freeserve.com/anytime