|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 5th, 2005, 10:00 PM
|
|||
|
|||
Numbering each record displayed in detail section of report
I'm a beginner so this might be a stupid questions, but...
My report lists all of the employees in a group. Is there a way that I can number the records in the first column? For example... 1 Employee Name and info. 2 Employee Name and info. 3 Employee Name and info. 4 Employee Name and info. .... Any help is much appreciated. 
|
|
#2
October 5th, 2005, 10:19 PM
|
|||
|
|||
|
Good question but one that is answered quite often.
Add a text box in the detail section and set its properties Control Source: =1 Running Sum: Over Group (or Over All) -- Duane Hookom MS Access MVP -- "ETC" wrote in message ... I'm a beginner so this might be a stupid questions, but... My report lists all of the employees in a group. Is there a way that I can number the records in the first column? For example... 1 Employee Name and info. 2 Employee Name and info. 3 Employee Name and info. 4 Employee Name and info. ... Any help is much appreciated.
|
|
#3
October 5th, 2005, 10:23 PM
|
|||
|
|||
|
You can add a text box in the detail section
In the control source of this text box write =1 And change the running sum property of the field to yes. -- I hope that helped Good luck "ETC" wrote: I'm a beginner so this might be a stupid questions, but... My report lists all of the employees in a group. Is there a way that I can number the records in the first column? For example... 1 Employee Name and info. 2 Employee Name and info. 3 Employee Name and info. 4 Employee Name and info. ... Any help is much appreciated.
|
|
#4
October 5th, 2005, 10:29 PM
|
|||
|
|||
|
It worked! Thanks so much.
"Duane Hookom" wrote: Good question but one that is answered quite often. Add a text box in the detail section and set its properties Control Source: =1 Running Sum: Over Group (or Over All) -- Duane Hookom MS Access MVP -- "ETC" wrote in message ... I'm a beginner so this might be a stupid questions, but... My report lists all of the employees in a group. Is there a way that I can number the records in the first column? For example... 1 Employee Name and info. 2 Employee Name and info. 3 Employee Name and info. 4 Employee Name and info. ... Any help is much appreciated.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| New record created in table when trying to edit displayed record | cleongatl | Using Forms | 0 | August 30th, 2005 10:01 PM |
| Keep Together last record detail with group footer | Craig | Setting Up & Running Reports | 1 | May 18th, 2005 07:33 AM |
| SubReport-Only last record from detail shows | SHIPP | Setting Up & Running Reports | 4 | May 12th, 2005 03:01 PM |
| Design help, please | SillySally | Using Forms | 27 | March 6th, 2005 04:11 AM |
| FIrst page footers | Noel S Pamfree | General Discussion | 7 | December 6th, 2004 08:49 PM |
Linear Mode
