Link to home
Start Free TrialLog in
Avatar of Svgmassive
Svgmassive

asked on

count records per page in ms access

I have an access report that i would like to count how much records on the page starting with the number 1.
thanks
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

in the report, create an unbound textbox
set the control source to =1

set the Running Sum to Over All or over group
Avatar of Svgmassive
Svgmassive

ASKER

that's no what i am looking for i am looking for a page total not a running sum nor group total.thanks
can you elaborate the page totals you are looking for.

better upload a sample db and explain what you want to see in the report
count how many records per page if  there's 10 records on a page the text box show display 10,if there's 8 then it should say 8, not looking for a running sum or group total.
running sum would be 18,if there one  group it would be 18 also and that's not what i am looking for i have those already.Thanks
i have no grouping levels on the report.
You'll have to do this in VBA.

Take a look at this article for the code, under the heading "Placing a Count in a Page Header or Footer":

http://office.microsoft.com/en-us/access-help/counting-in-reports-HA001137763.aspx
ASKER CERTIFIED SOLUTION
Avatar of Hamed Nasr
Hamed Nasr
Flag of Oman image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Did you actually take the time to read the article or did you simply "pick an answer' to close the question, get it off of your abandoned questions list, in order to get past the site's automatic lock so that you could post your new question?