Help creating a a numbered list

[freeskier]

Hello,

I have a list of names ordered alphabetically. How can I make a report that adds a number next to each name? The Count() function will return a total count which is close but not exactly what I want.
example:

1. Alyssa
2. Brett
3. Cacie
4. Charlie

Thanks in advance for your help in this matter

[NeoPa]

Hello,

I have a list of names ordered alphabetically. How can I make a report that adds a number next to each name? The Count() function will return a total count which is close but not exactly what I want.
example:

1. Alyssa
2. Brett
3. Cacie
4. Charlie

Thanks in advance for your help in this matter

There is nothing in Access (or any RDBMS) which supports this concept.
However, if you define a VBA function which returns sequential numbers it can be made to work.
It would have to be called before the query is run and remember the last number returned.
Alternatively, you can do it in a report.

[freeskier]

There is nothing in Access (or any RDBMS) which supports this concept.
However, if you define a VBA function which returns sequential numbers it can be made to work.
It would have to be called before the query is run and remember the last number returned.
Alternatively, you can do it in a report.

sorry, I was very unclear in my last post. I have a query that gives me an alphabetized list of people. I want to make a report that assigns a number to each person going from a-z.

[NeoPa]

My answer would be the same. I don't see how this effects the question.

[freeskier]

thank you for your input

[nico5038]

Place a new field in the report with as controlsource:
=1
Now go in the properties to the Data tab and set the Running Sum property to "Over all"

That's all.

Nic;o)

[freeskier]

Place a new field in the report with as controlsource:
=1
Now go in the properties to the Data tab and set the Running Sum property to "Over all"

That's all.

Nic;o)

thanks, that's perfect. nice trick

[NeoPa]

Sorry guys. I should have explained myself better in post #2 about the report. You've got a good answer now anyway :)