Conditional Sum?

T

Todd

I have a continuous form called "frmAssets"
The two fields I'm working on are [AssetValue] and [AssetType]
How can I set a textbox to sum all [AssetValue] where [AssetType] = "IRA"?

Thanks!
 
K

KARL DEWEY

Build a separate query that gives you that results. Add a Listbox to your
form header and use the query as record source.
 
S

Steve Schapel

Todd,

Put an unbound textbox in the Footer section of the form. In the
Control Source, use this expression...
=Sum(IIf([AssetType]="IRA",[AssetValue],0))
or...
=-Sum([AssetValue]*([AssetType]="IRA"))
 
Top