Record numbering 1

[dday01]

Hi All,

I have a report based on a query. Each record in the query has the record number from table I am querying on. My query returns a percentage of the records from the table. In my report I want to include the record number, but I don't want the gaps. when the records display in the report i want then to go 1,2,3,4,5 not 1,4,7,8,9 etc. Is there a way to renumber the records in the query or is there a way to just add a field to the detail section in my report that just increments by 1. I know this is probably an easy thing to do but I am a complete novice. Any help is appreciated.

Thanks,

D

 

[RoyVidar]

Yup - add a text control to the detail section, and alter the following properties:
Running Sum: Over All (or Over Group)
Controlsource: =1

Roy-Vidar

 

[dday01]

That did the trick, thanks alot Roy!

D