Taking a fields output and multiplying by a number

[dabowles]

Hi,
I have a report that I am attempting to take the output of one field and manipulate the result of that field. How do it accomplish this? For example: I have a field called ServiceUnits. It is a numerical field. In the report, instead of it reporting out the contents of the ServiceUnit field for each record, I want it to take the contents and multiply it by .25 and print that instead for each record. So I have my ServiceUnits field displayed on the report. I went into my text box and edited it so it would look like this: =([ServiceUnits]*.25). Now what is wrong with this syntax? I have tried it as many different ways as I can think of and each time the report prints it prints #Error.
Thanks for your time,
David

 

[jebry]

Hi David!

Your text box probably has the same name as the field and Access is getting confused. Try renaming the text box. Be careful that Access doesn't change the control source when you rename the field, if it does, change the source back to the field name.

hth Jeff Bridgham
bridgham@purdue.edu

 

[CosmoKramer]

Your syntax is right, but use an unbound text box to display this calculated value....

HTH