G
Guest
I have a situation where I'm trying to design a query that will calculate the
ratio of one field to the average of 4 other fields for a given table. The
problem is that in some records one or more of the values that are in the
average calculation might be NULL. When this is the case, I'd like to modify
the calculation to the ratio of one field to the average of the remaining
fields that are not NULL. Is there a way to do this in SQL, or do I need to
use VBA?
ratio of one field to the average of 4 other fields for a given table. The
problem is that in some records one or more of the values that are in the
average calculation might be NULL. When this is the case, I'd like to modify
the calculation to the ratio of one field to the average of the remaining
fields that are not NULL. Is there a way to do this in SQL, or do I need to
use VBA?