Detail Section in Report Keeps on Repeating

Pipo

Registered User.
Local time
Today, 11:06
Joined
Jan 13, 2016
Messages
23
As the title suggest the Detail Section on MS Access report keeps on repeating. Im quite new to Access so I have no idea whats going on and how to solve this.

See attached for reference.

Background on my report.
-All the text boxes are unbound
-I got the data using the Dsum function
Code:
DSum("GrantRel", "Tbl_Liquidation", "MONTH(RecDate)= " & no1Date & " AND YEAR(RecDate)= " & yrNo & "")
-All the data displayed came from a table except the one in the middle column
-The data in the middle column is the difference of the two other column(right column - left column)

The window with report is a form where a user can select the Region, Year and the Months to display and compare.
 

Attachments

  • report.png
    report.png
    51.7 KB · Views: 239
What is the recordsource of your report?
I think the problem lays here, the detail section would repeat so many times as rows in the recordsource!
Instead of unbound text controls, do the calculation in a query and use the query as recordsource for your report.
 

Users who are viewing this thread

Back
Top Bottom