[AccessD] FW: Formula in Report not Calculating

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