Results 1 to 3 of 3
  1. #1
    Meteo is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    9

    Question How to add summary text box without field repeating

    Hi all,



    I am trying to get one and only one textbox added to the detailed section of a blank report that has been sourced to a query that will give the total count of all issues without having to have all the issues displayed. I know I can group and get totals by displaying all the records, but I just won't this one text box on the detail section. Right now it duplicated all the issues and gives me the correct totals. I have used this as the event code in the text box "=count([qryName]![Issue Name]". I have labelled it "Count Issues"

    What it displays is this:

    Count Issues 77

    Count Issues 77
    .
    .
    .
    <repeat 77 times>

    Once again I just want it to say once Count Issues 77 and that is all I want on the page and I don't want to hide any fields.

    Thanks for your help ... Meteo

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,646
    Put the textbox in a group or page or report header/footer.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Meteo is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    9
    Thanks very much. The page footer didn't work but the report footer did the trick

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

Similar Threads

  1. Repeating Function
    By Code5OnYou in forum Forms
    Replies: 4
    Last Post: 01-12-2012, 01:55 PM
  2. Repeating data in a field for a new record
    By NOTLguy in forum Forms
    Replies: 3
    Last Post: 10-29-2010, 07:27 PM
  3. Repeating Records
    By windwardmi in forum Reports
    Replies: 13
    Last Post: 05-22-2010, 02:54 PM
  4. Replies: 2
    Last Post: 05-05-2010, 02:52 PM
  5. Split text field into two text fields
    By Grant in forum Access
    Replies: 6
    Last Post: 01-31-2008, 05:52 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