Results 1 to 1 of 1
  1. #1
    Join Date
    Oct 2012

    Unanswered: Problem About Report - Access 2003

    Hi everyone,

    I have a problem about report, Access 2003. Please find the attached db file and see details explained below.

    1. Open Form "frm_Header_and_Detail"
    2. Click "3. ดูรายงาน : แบบละเอียด"
    3. Enter the Start Date as "10/10" and End Date as "11/10" and click below button "คลิก เพื่อดูรายงาน"
    The report will display as shown in picture 001 attached
    4. In this report, the column "เลขที่" (The First column), "รับชำระ" (The Tenth column) and "เงินทอน" (The Eleventh

    column). I configured the Properties "Hide Duplicates = Yes".
    5. The sum of "รับชำระ" (The Tenth column) and "เงินทอน" (The Eleventh column) are wrong.
    The sum suppose to be 200 + 1,000 + 1,000 + 1,500 + 1,000 + 1,500 = 6,200

    I don't know how to make Access go to pull the data from the Duplicate Field only once to calculate. Please advise!

    Thank you very much in advance for your kind help.

    Best regards,

    Attached Thumbnails Attached Thumbnails 001.png  
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts