Edit control source

[mike]

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

 

[Duane Hookom]

The Control Source is a data property of the text box.

 

[mike]

Understood. Where is the expression for the data property CostLast set? i.e.
Quantity * Cost

 

[Duane Hookom]

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.

 

[mike]

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