Edit control source

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

A program we use has a field named TotCost for each line item in the body of
a report. When the report is run, the data displayed for TotCost is the
result of multiplying Quantity by Cost for each line item. Now I want
TotCost to be the result of Quantity x Cost x Markup. I believe TotCost is a
control source but do not see how I can edit it. Where can I find this
control source so I can edit the expression?

Thanks
 
Understood. Where is the expression for the data property CostLast set? i.e.
Quantity * Cost
 
I'm having trouble understanding where you are at with this. Your report
should be open in design view. If you double-click a control on your report,
you should be able to see the properties dialog. If your control is a text
box, it will have a Control Source property. This is where you can specify a
field or expression to display.
 
The expression was not set in the Control Source property box. I found the
location of the expression in a query. In the query there is a Set TotCost =
Quantity * Cost . I added * Markup, defined the Markup variable and I'm all
set.

Thanks for the help
 
Back
Top