Labeling a record on a form

[ReportSmith]

When creating a report, there are a few 'sneaky' ways to have a "running"
label next to each record listed (ex: 1 xxxxx, 2 xxxxx, 3 xxxxx, etc). On a
form...not so much.

I thought of a running total (the first 'sneaky' way) - but that is not an
option. Next I thought of a Sum function...possible, but how?

Thanks in advance for any and all feedback.

 

[Jeff Boyce]

I seem to recall seeing something in the .queries newsgroup about creating a
field for "ranking" the rows returned by that query.

Try doing a search on "query" and "ranking", and base your form on the
query, not directly on the table.

Regards

Jeff Boyce
Microsoft Office/Access MVP