Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

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]
 
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
 
Back
Top