Field Calculation

[JGarza]

I have a REPORT that sums a column of information. I want Access to prompt me for a Unit Price to be multiplied by the sum.

For example:
2+3+6=11... Prompt me for a "unit price" = $2.00.... which will give me a total of $22.00.

 

[Dugantrain]

Base this report off of a query. Define a new field by:

New_Field:  ([Whatever Fields Get Added Go Here] * [Please Enter A Unit Price])

Of course, you can put whatever you want into the prompt, the important part is to wrap it in the opening and closing brackets.

 

[JGarza]

It didn't work...

Note that I am taking the SUM from a report footer and trying to multiply that by a unit price.

 

[Dugantrain]

Did you define this field in an underlying query and use that query to feed this report? If so, is the query acting like it should?

 

[JGarza]

I am not sure what you mean???

I went to the original query the report is pulling from, and added the formula you gave.

 

[Dugantrain]

Why don't you post the SQL that the query has built.
In the Toolbar, View->SQL and copy-paste what is written.