Using the SUM expression w/ numeric & text values? (1 Viewer)

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"?
 

Travis

Registered User.
Local time
Today, 04:36
Joined
Dec 17, 1999
Messages
1,332
Have you tried:

Sum(Val([YourFieldtoSum])
 

Users who are viewing this thread

Top Bottom