By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,662 Members | 1,790 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,662 IT Pros & Developers. It's quick & easy.

Help creating a a numbered list

P: 65
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
Jan 16 '07 #1
Share this Question
Share on Google+
7 Replies


NeoPa
Expert Mod 15k+
P: 31,271
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.
Jan 16 '07 #2

P: 65
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.
Jan 16 '07 #3

NeoPa
Expert Mod 15k+
P: 31,271
My answer would be the same. I don't see how this effects the question.
Jan 16 '07 #4

P: 65
thank you for your input
Jan 16 '07 #5

nico5038
Expert 2.5K+
P: 3,072
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)
Jan 17 '07 #6

P: 65
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
Jan 17 '07 #7

NeoPa
Expert Mod 15k+
P: 31,271
Sorry guys. I should have explained myself better in post #2 about the report. You've got a good answer now anyway :)
Jan 17 '07 #8

Post your reply

Sign in to post your reply or Sign up for a free account.