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
thanks
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
better upload a sample db and explain what you want to see in the report
ASKER
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.
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
:-0
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?
set the control source to =1
set the Running Sum to Over All or over group