Query and Null values

[dwaynesworld]

I have a query linked to a subreport that may have null entries based on
which individual's data is pulled. What I would like is to display the
subreport even if there are null values. This is my query

SELECT IIf(IsNull([Support Date]),"None",[Support Date]) AS [Date],
IIf(IsNull([Organization Name]),"None",[Organization Name]) AS [Org Name],
IIf(IsNull([Organization Hrs]),0,[Organization Hrs]) AS [Organization Hours],
IIf(IsNull([SME Activities]),"None",[SME Activities]) AS [SME Act],
IIf(IsNull([SME Hrs]),0,[SME Hrs]) AS [SME Hours],
qryIndividualBusSupportData.[Total Bus Spt Hrs]
FROM qryIndividualBusSupportData
GROUP BY IIf(IsNull([Support Date]),"None",[Support Date]),
IIf(IsNull([Organization Name]),"None",[Organization Name]),
IIf(IsNull([Organization Hrs]),0,[Organization Hrs]), IIf(IsNull([SME
Activities]),"None",[SME Activities]), IIf(IsNull([SME Hrs]),0,[SME Hrs]),
qryIndividualBusSupportData.[Total Bus Spt Hrs];


Please help

 

[John Spencer]

Do you mean that there will be NO records returned for a specific individual
or do you mean that the records returned for a specific individual will
contain null values in many or all of the fields?

Your subquery should generate values for nulls in fields where a record is
generated for an individual


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..