Expression in a report

[William]

I have a column in a report that is bound to field that has numbers. The
field name is Alloc. In the report I want a column which shows the amount in
the Alloc field multiplied by .15. Here is the expression I built, but which
returns the following in the report: # Error:

=[qryLapAllocList-09]!Alloc*0.15

What am I doing wrong?

 

[Jeff Boyce]

William

One approach might be to step back for a moment.

If you WEREN'T multiplying by .15, what would be in the Control Source?

You haven't described the source for the report, but can we guess that it is
a query named "qryLapAllocList-09"? If so, that is, if this query "feeds"
your report, then I suspect you only need:

=[Alloc] * .15

for the control's source.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[fredg]

I have a column in a report that is bound to field that has numbers. The
field name is Alloc. In the report I want a column which shows the amount in
the Alloc field multiplied by .15. Here is the expression I built, but which
returns the following in the report: # Error:

=[qryLapAllocList-09]!Alloc*0.15

What am I doing wrong?

Isn't the [Alloc] field included in the report's Record Source?
=[Alloc] * 0.15
Make sure the name of this control is not "Alloc".

 

[Fred]

Just to point a point on what FredQ said, it is a common and easy to make
mistake which I have made a gazillion times: If you started making this
control by dragging "Alloc" from the field list, then the default name of the
control IS alloc, which would cause your problem. You have to rename it.