Full Version: numbering fields of a report
UtterAccess Discussion Forums > Microsoft® Access > Access Reports
gouthamsworld
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
sarahfalk
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.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.