 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2008How can I create a field to total another field in a report?
Good Afternoon, I am creating a report based on input in a table that calculates ticket revenue from athletic events. I have the report completed and a total for each line. The report is based on a query so I can select only specific sports. How can I get an overall total for a particular sport? I have a control placed in the footer, but can't seem to get the correct expression . . I get an error. What expression(s) have you tried, and what error are you getting?  Signature_________ Sean Bailey > Good Afternoon, > I am creating a report based on input in a table that calculates ticket [quoted text clipped - 3 lines] > control placed in the footer, but can't seem to get the correct expression . > . I get an error. Hi BCHS, Open your report to Design view and click the Sorting and Grouping icon on your toolbar. When it opens, selct the sport field and at the bottom create header and footer. Place the Sports field in the header and a textbox in the footer. Open the properties of the textbox in the footr and in the control source type: =Sum([your field name you are trying to total]) and that should do it. This will total for each sport. If you want the grand total for ALL the sports on the report, copy the textbox and paste it in the Report Footer. If I understood your question that should do the trick. > Good Afternoon, > I am creating a report based on input in a table that calculates ticket [quoted text clipped - 3 lines] > control placed in the footer, but can't seem to get the correct expression . > . I get an error. I have tried this =Sum([text25]) is the control source and that is when I get the error. "text25" is a field that contains an expression calculating the total revenue generated from tickets sold for a single event, and I want the field in the footer to calculate a total based on the events that are selected when opening the report and typing in a specific sport. I hope I am explaining what I am trying to do well enough. > Hi BCHS, > [quoted text clipped - 15 lines] > > control placed in the footer, but can't seem to get the correct expression . > > . I get an error. You have to use the name that is bound. Each time you create a text box it will automatically be named Text23, Text 24 and so on. What is the name of the field that is bound to the query? > I have tried this =Sum([text25]) is the control source and that is when I get > the error. "text25" is a field that contains an expression calculating the [quoted text clipped - 23 lines] > > > control placed in the footer, but can't seem to get the correct expression . > > > . I get an error. It is named Text25 . . . > You have to use the name that is bound. Each time you create a text box it > will automatically be named Text23, Text 24 and so on. What is the name of [quoted text clipped - 27 lines] > > > > control placed in the footer, but can't seem to get the correct expression . > > > > . I get an error. >It is named Text25 . . . > [quoted text clipped - 7 lines] >> > field in the footer to calculate a total based on the events that are >> > selected when opening the report and typing in a specific sport. The problem is probably that you can Sum a *field value* but you cannot sum a *control name*. If Text25 is bound to some table field use =Sum([thatfieldname]). If Text25 has some expression as its control source use =Sum(<the same expression>) SignatureJohn W. Vinson [MVP] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.