Please give me an example of combined use of iif and isnull in access query?
MARKAND911 -1 Junior Poster
finito 46 Nearly a Posting Virtuoso
please read: http://msdn.microsoft.com/en-us/library/ms181765.aspx
SELECT FirstName, LastName, TelephoneNumber,
IIf(IsNull(TelephoneInstructions),"Any time",
TelephoneInstructions) AS [When to Contact]
FROM db1.ContactInfo;
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.