[AccessD] FW: Formula in Report not Calculating

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. 




More information about the AccessD mailing list