[AccessD] FW: Formula in Report not Calculating

That got rid of the formula error but still have the 4 identical records for each week

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

Looks to me as your prefixing the field names with the report name has
got it thinking you are referring to the controls of the same name. So
YES, change the names of the controls if they are there. And if you
are referring to fields in the underlying query you don't need
anything except the field names themselves, probably in square
brackets since they have embedded spaces in the names.

GK

On Wed, May 20, 2009 at 12:38 PM, Kaup, Chester
<Chester_Kaup at kindermorgan.com> wrote:
> 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
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



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