[AccessD] FW: Formula in Report not Calculating

Kaup, Chester Chester_Kaup at kindermorgan.com
Wed May 20 16:40:59 CDT 2009


They are in the query result because it has another field named Department Description that is different in each record but is not shown in 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 4:28 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] FW: Formula in Report not Calculating

Are those duplicates also in your query?

Susan H.


> Here is what part of the report looks like. Notice duplicates.
>
> Week     TY Sales  TY Actual   LY Actual    Pct chg Plan Vs    Pct Chg TY 
> vs
> Number     Plan      Sales      Sales            Actual              LY
> 1          950        971        876              46.24             9.22
>
> 1          950        971        876              46.24             9.22
>
> 1          950        971        876              46.24             9.22
>
> 1          950        971        876              46.24             9.22
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Elizabeth.J.Doering at wellsfargo.com
> Sent: Wednesday, May 20, 2009 2:53 PM
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] FW: Formula in Report not Calculating
>
> Oh.  And then your problem with extra rows in the detail will go away.
>
> I should have been a trifle more clear.  :)
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Elizabeth.J.Doering at wellsfargo.com
> Sent: Wednesday, May 20, 2009 2:40 PM
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] FW: Formula in Report not Calculating
>
> If you don't want to display the field Description, exclude it from the 
> query.  Then it will also be excluded from your report.
>
>
> Thanks,
>
> Liz
>
> 612.667.2447 (o)
>
> This message may contain confidential and/or privileged information. If 
> you are not the addressee or authorized to receive this for the addressee, 
> you must not use, copy, disclose, or take any action based on this message 
> or any information herein. If you have received this message in error, 
> please advise the sender immediately by reply e-mail and delete this 
> message. Thank you for your cooperation.
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
> Sent: Wednesday, May 20, 2009 2:29 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] FW: Formula in Report not Calculating
>
> Unfortunately hiding the duplicates is of no help. I get lots of blank 
> lines in the report and the totals at the bottom of the report includes 
> the hidden controls.
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
> Sent: Wednesday, May 20, 2009 2:11 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] FW: Formula in Report not Calculating
>
> Chester -- I thought earlier that you defined it as Description -- I'm 
> talking about the control that's displaying the duplicate values.
>
> Susan H.
>
>>I am missing something simple here. Where is the Description control in
>>the detail section of the report?
>>
>>> That got rid of the formula error but still have the 4 identical
>>> records for each week
>
> --
> 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
>
> -- 
> 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