Can you Ignore Null values in calculations

Status
Not open for further replies.

ptaylor-west

Registered User.
Local time
Today, 10:37
Joined
Aug 4, 2000
Messages
193
Is it possible to create a query that will use ingnore null fields when adding them together, I know I can use the Nz function to add the fields together if they are null, but equally if all the fields are null it returns a zero value. What I want to do is leave the fields blank if they are all null. I picked up the IGNORE NULL option for use in an Index and wondered if this could be used. Or does anyone have an alternative suggestion.

The problem I have is that zero does have a value in the output, whereas if it is left blank it means it has not been answered yet.
 
Status
Not open for further replies.

Users who are viewing this thread

Back
Top Bottom