Calculating the results of a calculated field

[Robert C]

I have a report on which I list projects worked on in any given month and the time spent working on them. The total time spent for the month is a summed total created in the query which forms the control source of the report.

On the report I then have a calculated field within the ProjectName header which tells me how much has been earned on each project - =([SumOfAccruedTime]/3600)*[RateChargable] and is shown in an unbound text box called Text30

What I want to show is the total earned on all projects within any particular month, bearing in mind that each project can have a different hourly rate.

I have tried simply inserting and unbound text box with a control of =Sum([Text30]), but this always returns an #Error.

I know this is a familiar topic and I have searched earlier posts, but with no success.

Any help would be gratefully received.

Cheers

Rob

 

[addy]

I'm not 100% sure but I think that if you do the =([SumOfAccruedTime]/3600)*[RateChargable] calculation in your query, rather than on your form, you should then be able do a sum of the query expression.

So, in your query, if you add an Expression in such as:

Total: ([SumOfAccruedTime]/3600)*[RateChargable]

Then in you report you should be able to do =Sum([Total])

Hope this helps / works.