[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