If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#N/A errors
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. |
#2
|
|||
|
|||
#N/A errors
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 Loren Newton wrote: 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. |
Thread Tools | |
Display Modes | |
|
|