[AccessD] Omit Records from Report Total

Gary -
That's a good idea.  I actually created a new field and updated it with
the same criteria you are using.  Then, I used this new field for the
totals.
Although, your idea involves less work.

Thanks,
Mark


-----Original Message-----
From: Gary Kjos [mailto:garykjos at hotmail.com] 
Sent: Thursday, November 06, 2003 4:02 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Omit Records from Report Total

I would do this with a query over the table with a second field for the 
Amount that had a value of something like;

AmountForNotLost: iif([ProposalStatus] = 'Lost',0,[Amount[)

and then use that query as the record source for the report and just
total 
on the AmountForNotLost instead of - or in addition to the regulare
Amount 
field.

Gary Kjos
garykjos at hotmail.com



>From: "Mark Boyd" <MarkBoyd at mcbeeassociates.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: <AccessD at databaseadvisors.com>
>Subject: [AccessD] Omit Records from Report Total
>Date: Thu, 6 Nov 2003 11:12:26 -0500
>
>I have a table with 3 fields: [Office], [ProposalStatus], and [Amount].
>
>In my report, I group on [Office], with [ProposalStatus] and [Amount]
in
>the Detail section.
>
>In the [Office] Footer, I have a textbox with a control source of
>'=Sum([Amount])'.
>
>However, I have been informed that this textbox should not include
>records with a [ProposalStatus] of 'Lost'.
>
>Therefore, I need the textbox to be the total amount of all records
that
>have a [ProposalStatus] <> 'Lost'.
>
>
>
>Is there any way to do this?
>
>
>
>Mark Boyd
>
>Sr. Systems Analyst
>
>McBee Associates, Inc.
>
>
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Is your computer infected with a virus?  Find out with a FREE computer
virus 
scan from McAfee.  Take the FreeScan now! 
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com