Results 1 to 3 of 3
  1. #1
    yayanpuji is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Aug 2013
    Posts
    8

    adding count of a column per page in footer, and erasing footer in the last page


    I have two problems here:


    1) how to add "count" of a column, in the footer?
    I want to add the amount of record in column 1 of my report, in the footer.
    Here I will give the screenshots:
    What my Access is now looked alike=
    Click image for larger version. 

Name:	screenshoot1.png 
Views:	6 
Size:	73.4 KB 
ID:	14049
    What I want to make (it is made in excel)=
    Click image for larger version. 

Name:	screenshoot2.png 
Views:	6 
Size:	39.1 KB 
ID:	14050


    2) I want to erase the footer in the last page of my report.
    Here I will give the screenshots:
    What my Access is now looked alike=
    Click image for larger version. 

Name:	screenshoot3.png 
Views:	6 
Size:	63.4 KB 
ID:	14051
    What I want to make (it is made in excel)=
    Click image for larger version. 

Name:	screenshoot4.png 
Views:	6 
Size:	26.0 KB 
ID:	14052

    I embedded my database. The report is on the "coba_Query".
    Attached Files Attached Files

  2. #2
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    the syntax for count in a footer is: =Count([fieldname])
    and that is entered as the unbound textbox's control

    one can make a footer not visible in its properties; a footer's properties is found when the report is in design view by highlighting the footer bar, right clicking and select properties...

  3. #3
    yayanpuji is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Aug 2013
    Posts
    8
    @NTC=
    Can you please fix my Ms. Access so that it can display report as in Ms. Excel?
    I will embed my Ms. Access and the desired report in Ms. Excel.
    The report is in "coba_Query".
    Attached Files Attached Files

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Group footer not showing on first page
    By TinaCa in forum Reports
    Replies: 1
    Last Post: 12-14-2012, 02:27 PM
  2. Page Breaks and the Report Footer
    By dssrun in forum Reports
    Replies: 4
    Last Post: 05-03-2011, 03:23 PM
  3. Page Footer
    By jamil_kwi in forum Access
    Replies: 1
    Last Post: 05-31-2010, 04:02 AM
  4. Replies: 0
    Last Post: 02-11-2009, 06:43 PM
  5. Page Footer Top
    By RHall in forum Reports
    Replies: 3
    Last Post: 12-15-2005, 09:35 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums