Susan Harkins
ssharkins at gmail.com
Wed May 20 12:21:40 CDT 2009
> Also, you mention that the domain functions are actually in the > query? Is this correct? YES > > Here is what the control source for the text box looks like > > =[Depatment Sales Analysis]![SumOfTY Actual Sales]/[Depatment Sales > Analysis]![SumOfTY Plan vs Actual] Are those field names or the names of report controls that contain the results of the aggregate functions from the query? Generally, it's a good idea to rename controls that you want to include in expressions -- especially where aggregates are concerned. Susan H.