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

Numbering Items in a Report

P: 22
Novice User Here.....

How do I "Number" my query results in the Detail section of a Report?

For example, if my query return 3 records...

Instead of the Report showing this way:

Paul
Charlie
Michael

I would like the Report to show it this way:

1 Paul
2 Charlie
3 Michael
Jan 4 '12 #1

✓ answered by NeoPa

Create a control on your report and make the formula =1. Next change the RunningSum property to True and you have a count.

Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,186
Create a control on your report and make the formula =1. Next change the RunningSum property to True and you have a count.
Jan 5 '12 #2

P: 22
Thanks. That did the trick. Like I said, I'm a novice. Your solution also taught me that it must be poor practice to name Table fields with a Number... like "1", or 2. I've changed those field names to "One" and "Two". I wasn't able to apply your solution until I renamed the field "1" to "One".
Jan 5 '12 #3

NeoPa
Expert Mod 15k+
P: 31,186
Frankly, having any fields named by a number, whether as a character or the text, is not a great idea. Please check out Database Normalisation and Table Structures. It's not directly about naming and how important it is that names are meaningful, but it may give you an understanding to help you realise this for yourself. It's certainly an understanding that you will be better off for if you plan to do anything with databases. Good luck :-)
Jan 6 '12 #4

Post your reply

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