Calculated Fields on reports

  • Thread starter Thread starter Aymanh
  • Start date Start date
A

Aymanh

Hi:

Help Please,

* I'm making a report out of a query.
* the query includes a detail order table that has all the details in the
purchase order
* the query also has a column of calculated field Extended price:
price*quantity

now when I make a report, I'm trying to sum the extended price calculated
values,
"I'm trying to sum all line numbers for the one purchase order", when I
create a calculated field in the footer, and then run the report I see
"Error#"

What is wrong?
 
What section do you mean by "in the footer". Should be either a group footer
or report footer. Also, the name of the control must not be the name of a
field. If you can't get this to work, copy your control source in a reply.
 
Back
Top