Kaup, Chester
Chester_Kaup at kindermorgan.com
Wed May 20 16:18:10 CDT 2009
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