Create consecutive numbers in a row based on user input

[agnelofer1]

I have list of candidates shown in report. I need each candidate to have a unique number based on user input. And this number increases by 1 for the rest of the candidates in the report.

Example is below:

If user enters 1132 in the user input box then the numbers shown in report should be as below:

Name Assignment Number

Felicity Thomas 1132
Andrew Sen 1133
Andy Luker 1134

Similarly if number entered is 2345 then the numbers shown in the report will be:

Name Assignment Number

Felicity Thomas 2345
Andrew Sen 2346
Andy Luker 2347

Any ideas or solutions?

 

[billmeye]

On your report create 3 additional controls GetStart, Increment and DisplayNumber.

For GetStart, the Control Source should be something like: [Please Enter the Starting Number]

For Increment the Control Source will be: =1 and set Running Sum to be Over All

For DisplayNumber the Control Source will be: [GetStart] + [Increment] - 1

For the controls GetStart and Increment set Visible to No.

Position DisplayNumber next to your Name and you will get what you are looking for.