Results 1 to 3 of 3
  1. #1
    kermit is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    May 2015
    Posts
    2

    Report displays data multiple times

    I have created a report from a query and have utilized the count if function in the details - =Count(IIf([day of week]="SUNDAY",1)). I have done this for each day of the week. The data shows all seven days and the proper count but then displays the info multiple times afterwards. I have tried multiple things to correct this to no avail and even utilized a different database and experimented with success. I even redid the database from scratch and the same problem exists.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Is textbox in Detail section? Maybe needs to be in report or group footer section.
    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
    kermit is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    May 2015
    Posts
    2
    I put it in the report footer section and it worked!!!!!!!!! Thanks so much, I have been racking my brain for days!!!!!

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

Similar Threads

  1. Replies: 8
    Last Post: 09-24-2014, 12:37 PM
  2. Replies: 4
    Last Post: 06-12-2014, 03:06 PM
  3. Replies: 1
    Last Post: 12-02-2012, 02:10 AM
  4. Replies: 27
    Last Post: 08-14-2012, 09:05 AM
  5. Replies: 5
    Last Post: 12-10-2009, 10:33 PM

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