hi i hav a report as below



university sport teams

1 1.


2.


3.

this is the just the part of a report there are like 100 uni's in the list
what i need is as the university is numbered 1 i want the teams in the university to be numbered 1.1,1.2 ,1.3

can somebody help me doing this???

thanks

you could create a field in your query that concatenates the ID's from teh uni and the team tables

= [tblUni.ID] & "." & [tblTeam.ID]

then create the report based on that query.

like attached.