• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1154
  • Last Modified:

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
0
Svgmassive
Asked:
Svgmassive
  • 3
  • 2
  • 2
  • +1
1 Solution
 
Rey Obrero (Capricorn1)Commented:
in the report, create an unbound textbox
set the control source to =1

set the Running Sum to Over All or over group
0
 
SvgmassiveAuthor Commented:
that's no what i am looking for i am looking for a page total not a running sum nor group total.thanks
0
 
Rey Obrero (Capricorn1)Commented:
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
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
SvgmassiveAuthor Commented:
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.
0
 
mbizupCommented:
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
0
 
hnasrCommented:
One way:
Text box in detail:
    name: recSum ,  controlSource=1, Running Sum over all, visible: no

Text boxes in page footer:
    name: recPrev,  visible: no
    name: recPage

Private Sub PageFooterSection_Print(Cancel As Integer, PrintCount As Integer)
    Me.recPage = Me.recSum - Nz(Me.recPrev, 0)
    Me.recPrev = Me.recSum
End Sub

Open in new window

0
 
Rey Obrero (Capricorn1)Commented:
:-0
0
 
mbizupCommented:
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?
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now