Show Record number n of m 1

[woter324]

Hi,

I have a report that currently has six records.

I'd like to have a textbox in the report detail section that shows "record n of 6" I can use count() to get the '6' value but how do I get the 'n' value?

I'm looking for something similar to the

 ="page " & Page & " of " & Pages

i.e.

 ="Record " & {what goes here?} & " of " & count([someTable.someField])

Many thanks in advance

Woter

 

[dhookom]

Add a text box to your detail section:
Name: txtCount
Control Source: =1
Running Sum: Over All
Visible: No
Then set your visible text box control source to:
=[txtCount] & " Of " & Count(*)

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[woter324]

Brillent.

Thank you very much. So simple