Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All,
Found this out the hard way, as the query and all child queries do not appear in the list of objects when connected to the Access Database as a source.
solution is to replace the convenient NZ() function with an IIF() statement
original
Nz(MAP.chkCOE,"n")
Replacement
IIf(Trim(MAP.chkCOE) = "" or IsNull(MAP.chkCOE), "n", MAP.chkCOE)
Cheers
Andrew