[AccessD] FW: Formula in Report not Calculating

I meant in the control source for the calculated control you are
getting the error in.

That should be just;

 =[SumOfTY Actual Sales]/[SumOfTY Plan vs Actual]

On Wed, May 20, 2009 at 1:10 PM, Gary Kjos <garykjos at gmail.com> wrote:
> 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
>



-- 
Gary Kjos
garykjos at gmail.com