Query missing data

[Christopherusly]

I have a lookup query which references tbl_projectdetails:

SELECT tbl_projectdetails.[Project Code], tbl_projectdetails.[Service Area], tbl_projectdetails.[Project Title], tbl_projectdetails.[Work Stage], tbl_projectdetails.[Project Director], tbl_projectdetails.[Project Manager], tbl_projectdetails.[Start Date], tbl_projectdetails.[Completion Date], tbl_projectdetails.[Gateway Date], tbl_projectdetails.LiveProject, DateDiff("d",Now(),[Completion Date]) AS [Days Left]
FROM tbl_projectdetails;

what i want to include is an expression that returns a value when any of the following fields have no value: (or contain any data)

tbl_projectdetails.[Project Title],
tbl_projectdetails.[Work Stage],
tbl_projectdetails.[Project Director],
tbl_projectdetails.[Project Manager],
tbl_projectdetails.[Start Date],
tbl_projectdetails.[Completion Date],
tbl_projectdetails.[Gateway Date],
tbl_projectdetails.LiveProject

the only column that will always contain something is the tbl_projectdetails.[Project Code]

Thanks you guys.

Christophe

 

[vbaInet]

It would depend upon whether what is returned is NULL or if it's an empty string. If it's NULL then just use the Nz() function:

http://www.techonthenet.com/access/functions/advanced/nz.php