Heatshiver
Registered User.
- Local time
- Today, 17:50
- Joined
- Dec 23, 2011
- Messages
- 263
I have a query that performs some calculations, these calculations feed into another query and produce a final value. If there are no null values everything works perfectly. But when there are null values, I get errors.
What I have tried:
1) I tried to implement the Nz function for each field of the formula that is not calculated but from user input.
2) I tried to implement the Nz function for just the field that calculated the last result before feeding into the next query, but it didn't show the 0 value I gave.
3) I tried to use UPDATE TABLE SET in SQL, but I don't think I was using it right. I tried to use it for all records but always got an error when it ran.
The first two above result in showing no values at all, even if there are some. The third didn't work. Does anyone have an idea as to how to easily update null values in the query to 0? All I could think of was to somehow use Criteria or SQL, but I'm open to other suggestions as well.
Any help is much appreciated!
What I have tried:
1) I tried to implement the Nz function for each field of the formula that is not calculated but from user input.
2) I tried to implement the Nz function for just the field that calculated the last result before feeding into the next query, but it didn't show the 0 value I gave.
3) I tried to use UPDATE TABLE SET in SQL, but I don't think I was using it right. I tried to use it for all records but always got an error when it ran.
The first two above result in showing no values at all, even if there are some. The third didn't work. Does anyone have an idea as to how to easily update null values in the query to 0? All I could think of was to somehow use Criteria or SQL, but I'm open to other suggestions as well.
Any help is much appreciated!