Thank you so much Missinglinq and PHV for starting my day off great!
IIF(IsNull([Company]),[First Name] & " " & [Last Name],[Company])
Worked like a charm!
Now that I see it laid out like that it totally makes since. The one I had typed in using my flawed logic was twice as long and of course...
Hi Everyone,
I'm sort of new to Access/databases and I'm using the 2010 version. I've setup multiple tables/reports and defined relationships between them with no issues so far with what I'm doing.
However I wanted to setup a Display Name field using a calculated data type.
In this particular...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.