skipit
Kid at heart
- Local time
- Today, 12:33
- Joined
- Feb 11, 2002
- Messages
- 17
Morning all,
Thanks to help from this forum I have the following SQL for one of my queries:
The part of the qry SQL in question is the part in red. So in qry design grid my field for "Spec" looks like so:
So the finished product would look similar to:
Specs:
Center ILD
200 - 300
CPF
120-200and so on..
My question is, how do I not show the text "Center ILD" if my field [CenterILD_Spec] has a null or zero-length string value and still have all the other values for "Spec" showup if their respective fields are not null? I have tried using IIF and IsNull but keep getting errors. I tried just entering IsNull in the Criteira of the Design grid but no help.
I read thru the help files and they are lacking or maybe I am being dense today.
Anyway, any help I can get I will be thankful for.
Thanks Skip
Thanks to help from this forum I have the following SQL for one of my queries:
SELECT [qryMain2-17].JCI_PN, [qryMain2-17].JeffCityPN, [qryMain2-17].ProgramID, [JCI_PN] & "
" & "" & "
" & [JeffCityPN] & "
" & "" & "
" & [Desc1] AS PartNum, "Center ILD:" & "
" & [CenterILD_Spec] & "
" & "CPF: " & "
" & [CenterCPFSpec] & "
" & "Hyst: " & "
" & [Hysteresis] & "
" & "Wing ILD: " & "
" & [WingILD_Spec] AS Specs, "PPAP Wt:" & "
" & [PPAP_Weight] & "
" & "PPAP Date: " & "
" & [PartPPAP_Date] AS PPAPInfo, [qryMain2-17].Customer
FROM [qryMain2-17]
WHERE ((([qryMain2-17].ProgramID) Like "*" & [Forms]![frmReportInterface]![cboProgram]));
" & "" & "
" & [JeffCityPN] & "
" & "" & "
" & [Desc1] AS PartNum, "Center ILD:" & "
" & [CenterILD_Spec] & "
" & "CPF: " & "
" & [CenterCPFSpec] & "
" & "Hyst: " & "
" & [Hysteresis] & "
" & "Wing ILD: " & "
" & [WingILD_Spec] AS Specs, "PPAP Wt:" & "
" & [PPAP_Weight] & "
" & "PPAP Date: " & "
" & [PartPPAP_Date] AS PPAPInfo, [qryMain2-17].Customer
FROM [qryMain2-17]
WHERE ((([qryMain2-17].ProgramID) Like "*" & [Forms]![frmReportInterface]![cboProgram]));
The part of the qry SQL in question is the part in red. So in qry design grid my field for "Spec" looks like so:
Specs: "Center ILD:" & "
" & [CenterILD_Spec] & "
" & "CPF: " & "
" & [CenterCPFSpec] & "
" & "Hyst: " & "
" & [Hysteresis] & "
" & "Wing ILD: " & "
" & [WingILD_Spec]
" & [CenterILD_Spec] & "
" & "CPF: " & "
" & [CenterCPFSpec] & "
" & "Hyst: " & "
" & [Hysteresis] & "
" & "Wing ILD: " & "
" & [WingILD_Spec]
So the finished product would look similar to:
Specs:
Center ILD
200 - 300
CPF
120-200and so on..
My question is, how do I not show the text "Center ILD" if my field [CenterILD_Spec] has a null or zero-length string value and still have all the other values for "Spec" showup if their respective fields are not null? I have tried using IIF and IsNull but keep getting errors. I tried just entering IsNull in the Criteira of the Design grid but no help.
I read thru the help files and they are lacking or maybe I am being dense today.
Anyway, any help I can get I will be thankful for.

Thanks Skip
