First, it should be known that I am not well-versed in SQL or VBL. I merely put together queries the amateur way.
I am having an issue whereby I need to do calculations in which one of the fields can (in some cases) be Null.
I have used the Nz function to put a Zero in the field on reports (or in the query) but Access doesn't recognize this as a true Zero.
How do I go about being able to do a calculation using the field that is Null?
Here is an example:
So here I know that [Ttl CCS >0 + PLA2>=200] should give me a 1. But because the field [Total Calcium Scores>0] has no records it returns a Null value.
When I try to add a field that has a value to a field that does not have a value, I get no results therefore, having used the NZ function in the query it uses a Zero as a placeholder.
Can anyone guide me on how to do this seemingly simple calculation.
thanks to All.