|
| 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
August 14th, 2008, 02:29 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
#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
August 14th, 2008, 02:56 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
#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 | |
|
|
Linear Mode
