Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Inserting Detail Line Numbers

Status
Not open for further replies.

b88bsr

Technical User
Aug 25, 2005
6
US
I'n Access 2000, how can I insert detail line numbers? Example of what I'm looking for is.

My report pulls from a query that pulls the name, address, and phone number of individuals in the database based on birth year. I would like to have them numbered 1 thru whatever on each detail line. This is being used as a draft list for baseball teams and the coaches will call out the "player number" instead of the player name.

For the life of me I can't find this in my Access Bible.

I don't want to use the player I.D. that is stored in the database.
 
Nevermind. Sometimes you just have to look harder. It ends up being:

Insert into detail
Object: Text Box
Under Properties:
Name: MyLineNumber
ControlSource: =1
RunningSum: Over Group
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top