SUMIF and Access
Posted on 2003-02-23
I'm new to most of this, so forgive me if this is a stupid question. Is there any kind of an equivalent to Excel's SUMIF function that can work in Access?
An example of what I'm wanting to do would be a bank savings account. In the table might be transactions labeled as deposits, withdrawls, or interest deposits. Would it be possible to have a sum of all deposits (ignoring withdrawls) WITHOUT having to have them grouped? In other words, I would like transactions sorted by date, but I would like a sum by type.