Sum

[kirnavi]

I need to sum a field based on whether the amount is below or above $1000000. I need to end up with two fields - one which totals all amounts under $1000000 and one that totals everything over or equal to $1000000. I can't figure out how to do a SUMIF in Access and I know this must be easy but I'm stuck!

 

[kmclane]

Try iif([yourfield]<1000000,Sum(yourfield),0) and the opposite for the other total you need. I think that might work, but I didn't test it.
Ken

- If you are flammable and have legs, you are never blocking a fire exit.
Mitch Hedburg