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