[AccessD] FW: Formula in Report not Calculating

Those are the field names in the underlying query. 

I did notice that the Name and the Control Source on the property sheet for the fields SumOfTY Actual Sales and SumOfTY Plan vs Actual are the same. Would it be good to change the control name?

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Wednesday, May 20, 2009 12:22 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] FW: Formula in Report not Calculating



> 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. 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com