Select Distinct Question

[Huey462]

I suspect the answer is probably "No", but I'll ask anyways.</SPAN>

I have the following select statement for a drop down box. Is there a way to add a blank/null line when the box is clicked?</SPAN>

SELECT DISTINCT [tblChecklist].CLName FROM tblChecklist ORDER BY [tblChecklist].CLName;</SPAN>

 

[james_lankford]

maybe

SELECT DISTINCT [tblChecklist].CLName FROM tblChecklist union all select NULL as CLName FROM tblChecklist ORDER BY CLName;

 

[Huey462]

Sorry for the late reply. This works...but there are ~300 blank lines with the remaining checklist names at the bottom of the list