I have a large database that I am trying to sum and make calculations from using text boxes using a report. I have set up the report and the calculations work, but they want to repeat themselves for every record. I cheated and chose "no duplicates" in the properties of the text boxes. Is there anyway to use all of the data but not have the output of the report want to repeat.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Calculations using text boxes
- Thread starter Matt1313
- Start date
If you put the calculating text boxes in the detail section of your report, they will repeat with every record. I put them in a summary section, or if you don't have a summary/totals section, put it in the page footer or report footer, whichever is most applicable. Sometimes I have reports that have totals by say location so in the grouping dialog, I request a location footer and I put any summary information, such as total text boxes in that section. If I just want a total.total, I put it in the report footer. Michelle Fulton
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question