Handling Nulls in Aggregate Query

[ClifCamp]

I have an aggregate query which pulls together calculation results from 4 different queries (each query provides a percentage). These four queries run off a table which changes monthly. Because of the nature of the data, one or more of the four queries may come up null in a particular month. The problem I am having is that if one of the four queries comes up null, then the aggregate query comes up null. Is there a way for the aggregate query to run despite the fact that one (or more) of the sub-queries is null? Thanks in advance for any suggestions.

 

[PHV]

Take a look at the Nz function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244