VBA Code

From TETTRIs
Revision as of 20:21, 9 April 2024 by WalterBerendsohn (talk | contribs) (Created page with "==(SPECIFY) Derive canonical name from FullName== Access-VBA in query: <br/> canonicalName: IIf(InStr(Nz([fullname]),":")>0,Mid([Fullname],InStr([fullname],":")+2),[Fullname])")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

(SPECIFY) Derive canonical name from FullName

Access-VBA in query:
canonicalName: IIf(InStr(Nz([fullname]),":")>0,Mid([Fullname],InStr([fullname],":")+2),[Fullname])

Retrieved from "https://wiki.bgbm.org/tettriswiki/index.php?title=VBA_Code&oldid=142"