Results 1 to 3 of 3
  1. #1
    Youngfighter is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Dec 2014
    Posts
    8

    Repeated Sum f each date in Report

    Hi all, I'm new to access and it's been working fine till now, and seems like my mind has stuck on a simple problem.

    I have table listing dates and number_of_items_sold, I've built a query and a table, and using Sum([number_of_item_sold]) in the report repeats the value for each date (I.E. if i choose a range of 3 days, it is repeated 3 times). Putting the sum in the footer or header gives me error.

    All I want is the sum of product for range of dates "that I entered as criteria" to use as subreport in another report.



    Thanks.

  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,816
    I don't use dynamic parameters in queries. I use VBA code to build filter criteria and apply to report (or form) when opening.

    I don't know what you are doing in report that causes error. If you want to provide db for analysis, follow instructions at bottom of my post.
    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
    Youngfighter is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Dec 2014
    Posts
    8
    Dear June7, appologies for the late reply, stupid me was putting the sum field in the report details section instead of the footer, sorted out now, thanks.

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

Similar Threads

  1. Repeated information
    By migaccess in forum Access
    Replies: 2
    Last Post: 12-05-2014, 09:13 PM
  2. Repeated Queries and updated data
    By jppevy in forum Access
    Replies: 1
    Last Post: 09-13-2013, 04:35 PM
  3. Same Field repeated with different values.
    By Betra in forum Queries
    Replies: 1
    Last Post: 09-24-2011, 02:06 PM
  4. Hi, How do we avoid repeated records?
    By radicrains in forum Queries
    Replies: 11
    Last Post: 11-04-2010, 03:00 AM
  5. Combo Box without repeated values
    By SCFM in forum Access
    Replies: 2
    Last Post: 02-20-2010, 05:57 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