Summing in Report

[joeydeck]

Hello,


I have created a report and i am having trouble with the =Sum() function. I would like to sum all the values that are held in a text box which has the expression of '=[BookingSF_Qry subreport].[Report]![TotalSF]*[HowManyDays]'. No matter what i try i cant get a total value of all of these.

Do you have any suggestions?

[JoeM]

Are you placing your SUM formula TextBox in a Footer section?

[joeydeck]

Yes, I have tried the =Sum() expression in all footers. None of them seem to work...

Thanks
Joe

[JoeM]

What is your exact SUM formula?
Are you summing the name of the Text Box that the calculation is done in?

Do any of the underlying calculations that you are trying to SUM return blanks, errors, or NULLs?

[joeydeck]

=sum([BookingSF_Qry subreport].[Report]![TotalSF]*[HowManyDays]), i have tried it in many diffferent ways....
=sum([RecTotal])

I have tried to put the expression into the query source and that didnt help.

Thanks
Joe

[JoeM]

What about my other question?

What does your attempted SUM return? An error, a blank, the wrong value?

[joeydeck]

Sorry, i forgot about that one...
No it doesn't return any value or error

[JoeM]

I think this is one where we may need to see your report to see if we can tell what is going on. You can upload/attach a copy of your database, so people here can take a look at it. Just be sure to remove any personal or sensitive information.

Unfortunately, I am not at a location where I can download files from the internet, but I will be tonight. However, someone else here may chime in too.

In the meantime, you may want to take a look at a few articles on the internet, like this one: http://office.microsoft.com/en-us/ac...010120854.aspx

[joeydeck]

Thank you for this. I have attached a copy of my database.

Cheers
Joe

[orange]

Joey,

When I opened your database and went to the report design, I noticed that your textbox to show the Sum(PricetoHire) had its visibility property set to NO.
Change the Visible Property to Yes and try it.

Good luck.

[joeydeck]

That is the only calculation that is working. I set it to not visible. It is on the DateStaff_Rpt,

Thanks
Joe

[orange]

I looked at the BookingSF sub report.

I have no idea what parameters I'm suppose to enter after opening DateStaff_Rpt.
Perhaps you could clarify in plain English what exactly is the issue. Which forms, what parameters, your expectations, etc.

This should be a guessing game, so more clarity please.

[joeydeck]

Sorry im being a noob here.

If you enter - 6/3/13,9/3/13 & perry that will bring up some data in the Datestaff_Rpt. The issue i am having is not being able to =sum() the total of each record. in this case this is a text box with a calculation of '=[BookingSF_Qry subreport].[Report]![TotalSF]*[HowManyDays]'. This is called RecTotal.

I would like textbox 'text145' to sum all of the [RecTotals]

Thanks
Joe

[orange]

??? Ehen i put in your values 6/3/13,9/3/13 & perry, I got prompted for RecTotal ????

[joeydeck]

yes that is the problem. That is because the Text box with the calculation cannot find the value of RecTotal. If you delete this in Design view this parameter box doesnt show.

cheers
Joe