Sorting by team.

[mjohnson629]

Hey everyone,

I am working on a database for a "Biggest Loser" competition. I am trying to make a report that will take all the weights of people in a certain team from a certain week (there are 8 fields for the 8 weeks of the competition) and get their sum and then display the information in a report. I want to be able to display the information on one team on one page.

Any tips will be great. Thanks...

Matt Johnson

 

[Smart]

Group by team in the team group footer place a page break