ptaylor-west
Registered User.
- Local time
- Today, 01:54
- 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.
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.