S
Sboynton
Guest
I am attempting to total a record on a report. It is dollar amounts for the most part, but there are some cases where the dollar amount is unknown, so "unknown" is just typed in the field instead of the number. When I go to calculate the record in my report using the SUM expression, I get an error. Is there a work-around for this, so that Access can add up all the numbers and just leave out the "unknowns"?