[AccessD] Omit Records from Report Total

Thanks Stuart.
I thought it should be this easy, I just couldn't figure it out.

Mark

-----Original Message-----
From: Stuart McLachlan [mailto:stuart at lexacorp.com.pg] 
Sent: Thursday, November 06, 2003 5:39 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Omit Records from Report Total

Use: 

=Sum(IIf([ProposalStatus]="Lost",0,[Amount])

On 6 Nov 2003 at 11:12, Mark Boyd wrote:

> 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
> 

 
-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System Support.



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