Can a report filter or do i need multiple queries???

[Muzicmn]

first of all let me thank all of you for your continued support through my struggles with access. Sometimes i dont think i will ever get as good as i would like to with it but i keep pressing on

here's my latest delima:

I have 4 areas with 7 teams per area. Training is assigned to all or certain areas. in tracking who has not accomplished the training i am tasked in creating a report. The suggested report style would be like an excel sheet as follows:

TrainingItemID

Team1 Team2 Team3 Team4 etc...
Davis Baltimore Jones
Smith Deak Lopez
Wetton O'Conner


Now, the delema is that i have my training table set with the fields "AreaID" and "TeamID" when quieried all teams show up (which is what i need).

ie:
TrainingItemID

Davis Team1
Smith Team1
Wetton Team1
Baltimore Team2
Deak Team 2
Jones Team3
O'Connor Team 3

Now to get the report to spread the info into different "columns" is the problem. Is there a way to have the report split the names based on team or should i need to have multiple queries working together in order to create the main query used to create the report.

I assume if i need the latter then i must have 7 queries, 1 per team, and another query to tie them all together. And this is per area so i am looking at 8 per area at 4 areas 32 queries?? i know i can accomplish it this way but i think there must be an easier way to do this

thanks again for your suggestions

Ricky

 

[RV]

You can set up a grouping by team in the report itself.
Open the report in design view, click right on the top left square, choose Sorting and Grouping and enter the appropiate grouping.

RV