Access

[Guest]

I am trying to calculate a total on a report. The popup message ask for a
parameter for 'e-rate'. following is the code. What am I doing wrong??
'e-rate' contains an amount ($25.00).

=[act-hours]*[e-rate]

 

[Guest]

When creating a calculated field in the Report Footer you need to make sure
of few things:

1. Make sure the names spelled correctly

2. The field specified: [act-hours] and [e-rate] need to be in the report
RecordSource

3. You can't use calculated field in the report and use it name in the
report footer
for example:
if you have in the report details a text box named "FieldName" and in the
control source you have =Field1 + Field2
If you want to sum this field in the report footer, you won't write
=Sum(FieldName)
Instead you will write
=Sum(Field1 + Field2)

4. Make sure that the text box you have calculation in doesnt have the same
name as one of the name in the calculation
For example:
TextBox name "Text1"
In the control source of that text box you can't use
=[Text1]+[Text2]

5. Make sure that the problem is not with the report RecordSource - by
running it without the report

 

[Alex Dybenko]

Hi,
calculate this total in report's underlying query

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com