Default Query results.

[jlepack]

I have this query:

SELECT tblA.*, tblB.cID
FROM tblA LEFT JOIN tblB ON tblA.fNum = tblB.fNum;

Now I want to see all the records from tblA and the cID from tblB if
there is one. Now if there isn't a matching cID I want it's value to
not be blank. I want it to be "Does Not Exist".

How do I do that? Solution referably in Query design view.

 

[John Spencer]

SELECT tblA.*
, IIF(tblB.cID is Null,"Does Not Exist",tblB.cID) as cID
FROM tblA LEFT JOIN tblB ON tblA.fNum = tblB.fNum;

Or use the Visual Basic NZ function.
SELECT tblA.*, Nz(tblB.cID,"Does Not Exist") as C_id
FROM tblA LEFT JOIN tblB ON tblA.fNum = tblB.fNum;

 

[jlepack]

Thank you very much.

SELECT tblA.*
, IIF(tblB.cID is Null,"Does Not Exist",tblB.cID) as cID
FROM tblA LEFT JOIN tblB ON tblA.fNum = tblB.fNum;

Or use the Visual Basic NZ function.
SELECT tblA.*, Nz(tblB.cID,"Does Not Exist") as C_id
FROM tblA LEFT JOIN tblB ON tblA.fNum = tblB.fNum;