Max Wanadoo
max.wanadoo at gmail.com
Wed May 20 16:49:47 CDT 2009
Chester, Jumping in a bit late, but it sounds to be as if your query needs sorting out. Susan asked the appropriate question and your reply indicated this was the reason. You need to put the expression that creates the duplicates into a sub-query which only returns on response and then link that to your query. I come across this frequently. If you cannot find which tbale/field "is the culprit", count the records in the query, then delete each of the table/query until the number reduces to what you know is the right answer and then work on that. Probably not explaining it too well. Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester Sent: 20 May 2009 22:41 To: Access Developers discussion and problem solving Subject: Re: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com