adding records in a query

[dola]

I am hoping to be able to add numbers to the names I have listed in a query. For instance

1 John Do
2 Jane Smit
3 Lise Scot

So it counts the total number of people or records returned. i am sure this is possible but I can't get it to work

THANKS

DOLA

 

[Gary Walter]

I am hoping to be able to add numbers to the names I have listed in a query. For instance,

1 John Doe
2 Jane Smith
3 Lise Scott

So it counts the total number of people or records returned. i am sure this is

possible but I can't get it to work.Hi Dola,

You can return this "rank" in a query
using correlated subquery, but a simpler
method may be to do this in a report.

You typically want to show your user
results of a query in a report...and it does
not get any easier to "add these numbers"
than in a report.

In detail section of report, create an unbound
textbox. In the Properties for this textbox

Set its Control Source to

= 1

Set its Running Sum to "Over All"

Pretty simple, huh?

Good luck,

Gary Walter