Navigation Button Help

A

Andy Paris

Hi..

I need some help how can i get the number which is shown at the
Navigation Buttom at the bottom of the form in a report with other
fields??? Is it possible??

thanks
 
A

Allen Browne

The number shown in the Nav Buttons at the bottom of a form is not
consistent. It changes, depending on how the records are sorted, filtered,
or when new records are added or old ones deleted. It is therefore not
something consistent, so you cannot match it in a report.

If you just want to number the records in your report (similar to the way
the Nav Buttons number the records in a form), it's very easy. See:
Numbering Entries in a Report or Form
at:
http://allenbrowne.com/casu-10.html
 
H

HiTechCoach via AccessMonster.com

If you are wanting a count of record to print on the report then try this in
the control source of a text box in the report footer

=Count(*)

Andy said:
Hi..

I need some help how can i get the number which is shown at the
Navigation Buttom at the bottom of the form in a report with other
fields??? Is it possible??

thanks

--
Boyd
Hi Tech Coach
http://www.hitechcoach.com

Message posted via AccessMonster.com
 
A

Andy Paris

Allen said:
The number shown in the Nav Buttons at the bottom of a form is not
consistent. It changes, depending on how the records are sorted,
filtered, or when new records are added or old ones deleted. It is
therefore not something consistent, so you cannot match it in a report.

If you just want to number the records in your report (similar to the
way the Nav Buttons number the records in a form), it's very easy. See:
Numbering Entries in a Report or Form
at:
http://allenbrowne.com/casu-10.html

thanks a lot but the link is not working-
 
A

Allen Browne

Please try again: it's working for me at present.
Post back if you still can't get it.

The idea is so simple: text box in the report with properties:
Control Source =1
Running Sum Over Group
 
A

Andy Paris

Allen said:
Please try again: it's working for me at present.
Post back if you still can't get it.

The idea is so simple: text box in the report with properties:
Control Source =1
Running Sum Over Group
Thanks it works now...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top