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
-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.
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 & "")
-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.