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
|
|||
|
|||
Make table query with derived fields
I am trying to create a make table query that contains an end value dervied
from numberic fields within the table. I have 9 different columns where I need to add the values and in the made table, add an additional field which details the total for each row. So: Expr1: [Field1]+[Field2]+...+[Field9]. However where the fields are empty, the function is not operating and just returning Expr1 as blank. Short of running an update to query to update all blank cells in Field1-9, there must be an easier way!!! Help. |
#2
|
|||
|
|||
Andy wrote:
I am trying to create a make table query that contains an end value dervied from numberic fields within the table. I have 9 different columns where I need to add the values and in the made table, add an additional field which details the total for each row. So: Expr1: [Field1]+[Field2]+...+[Field9]. However where the fields are empty, the function is not operating and just returning Expr1 as blank. Sounds like you want to use the Nz function: Expr1: Nz([Field1],0)+Nz([Field2],0)+...+Nz([Field9],0) -- Marsh MVP [MS Access] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Toolbars, Drop-Down Menus | Rick | New Users | 1 | September 21st, 2005 11:17 AM |
Multiple Options Group | Patty Stoddard | Using Forms | 19 | August 4th, 2005 02:30 PM |
Table Design | A. Williams | Database Design | 3 | April 29th, 2005 07:02 PM |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
Big number gives error! | Sara Mellen | Running & Setting Up Queries | 8 | October 11th, 2004 02:48 AM |