#N/A errors

L

Loren Newton

I am trying to sum a colume that has some cells with '#N/A'. The cell with
the total, displays a '#N/A' now. How can I have that cell display the total
of the numbers entered when there are the errors in the sumed cells. Thanks.
 
J

John Spencer

It seems that the field is a text field, so you should be able to use the
following in a query to get a sum. THe expression should also work in a
report or on a form.

Sum(Val([Some Field] & ""))

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
Top