If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Query and Null values
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 |
#2
|
|||
|
|||
Query and Null values
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 .. "dwaynesworld" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|