[AccessD] Omit Records from Report Total

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.