[AccessD] FW: Formula in Report not Calculating

Kaup, Chester Chester_Kaup at kindermorgan.com
Wed May 20 14:04:35 CDT 2009


I am missing something simple here. Where is the Description control in the detail section of the report?

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

Chester, I can't promise this will do what you're looking for, but give it a 
try:

1.) In the Detail section, double-click the Description control to display 
its properties.
2.) Set the Hide Duplicates property to Yes.

Susan H.


----- Original Message ----- 
From: "Kaup, Chester" <Chester_Kaup at kindermorgan.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Wednesday, May 20, 2009 2:30 PM
Subject: Re: [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
>
>
> -- 
> 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





More information about the AccessD mailing list