Enter Parameter Value Dialog Box

[Nanette]

I used the expression builder to multiply two fields in a report:

= [tblMasterList]![Qty] * [tblMasterList]![Price]

When I run this I get a Dialog Box: Enter Parameter Value. If I enter a
parameter value, I get a #Error on every line where the answer should be.

All I want is to have every row of data multiplied on each line.

What do I do?

 

[kingston via AccessMonster.com]

Add the two fields to your report. Make them invisible or hide them if you
don't want them to appear in the actual report. Then create a control with
the value =[Qty]*[Price].

I used the expression builder to multiply two fields in a report:

= [tblMasterList]![Qty] * [tblMasterList]![Price]

When I run this I get a Dialog Box: Enter Parameter Value. If I enter a
parameter value, I get a #Error on every line where the answer should be.

All I want is to have every row of data multiplied on each line.

What do I do?

 

[Nanette]

Thanks Kingston, that worked.

I even understand that, when using the Build function, I was attempting to
pull info from the original table instead of pulling the data on the report.

Add the two fields to your report. Make them invisible or hide them if you
don't want them to appear in the actual report. Then create a control with
the value =[Qty]*[Price].

I used the expression builder to multiply two fields in a report:

= [tblMasterList]![Qty] * [tblMasterList]![Price]

When I run this I get a Dialog Box: Enter Parameter Value. If I enter a
parameter value, I get a #Error on every line where the answer should be.

All I want is to have every row of data multiplied on each line.

What do I do?