I'm sure this should be simple, but darned if I know how...
I'm doing a report in VB2005. I have a table linked to 3 columns of a view. Here's a sample of the data:
ColumnA ColumnB ColumnC
001 Physician $100.00
001 Nurse $ 50.00
001 Aide $ 25.00
002 Tractor $999.99
002 Jeep $500.00
002 Bicycle No Charge

What I want is 3 columns on the report, suppressing the duplicates in ColumnA, with a box around each major grouping.
So it would show: (excuse the half-a** boxes)
ColumnA ColumnB ColumnC
--------------------------------------|
|001 Physician $100.00 |
| Nurse $ 50.00 |
| Aide $ 25.00 |
--------------------------------------
|002 Tractor $999.99 |
| Jeep $500.00 |
| Bicycle No Charge|
---------------------------------------

I'm somewhat proficient using vb6, but am trying to move towards the .net version. Help!!!

Thanks
Steve