Help with Formatting a Report

[marksparro]

Im sending data from Microsoft Frontpage and saving it into an Access database. I need some help in the way the data shows up in my report. Here is the data thats in my table :

1 2
BBall Wycheck
BBall Frank
BBall Jeff
BBall Mark
Camps Wycheck
Camps Frank
Camps Mark
VBall Wycheck
VBall Mark

I want the report to have column headings for each of the different items under column 1, with all the names that correspond to it underneath it. For example :

BBall Camps VBall

Wycheck Wycheck Wycheck
Frank Frank Mark
Jeff Mark
Mark

Any help will be appreciated.

 

[nberryman]

Try the report Wizard.

One of the steps asks if you want to group on any fields. It will then do it for you

Neil Berryman
IT Trainer
neil_berryman@btopenworld.com