gaf44
Last Activity: Nov 14 '13, 03:53 AM
Joined: Nov 11 '13
Location:
-
Hey, Thanks NeoPa!Last edited by NeoPa; Nov 14 '13, 11:22 PM. Reason: Removed new question. Please post in separate thread. Only one question per thread. -
Thank you, "CA in the UK". That worked well. I appreciate the help. Best regards, GerryLeave a comment:
-
Addition expression that handles null values
Hi,
I am trying to write an expression that will add two fields that sometimes can contain Null values. Retaining the 'null' aspect is important because I need to know when no data at all was recorded for a particular row.
At first I tried this code:
However, if both fields are Null then it spits back 0. I want it to stay null.Code:LY34_SUB1: Nz([LY3_TREE_SUB1],0)+Nz([LY4_TREE_SUB1],0)
... -
NeoPa,
Thanks that works perfectly!
GerryLeave a comment:
-
Average expression that can handle null values
Hi, I am trying to create a make-table query that includes an expression which will average four fields.
My problem is that the fields contain null values for certain rows.
I want the expression to take the average of the non-null values (including zeros) within the four fields and disregard the nulls.
Here's a table describing what I want my outcome table to show:
...Code:ID Field1 Field2
Last edited by zmbd; Nov 11 '13, 10:46 PM. Reason: [Z{Please use the [CODE/] button to format posted code/html/sql/formated text - Please read the FAQ}]
No activity results to display
Leave a comment: