Access
A family of Microsoft relational database management systems designed for ease of use.
336 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I've got a table with three fields [First] [Last] and [Nickname]. I've created a third field to calculate them together as
[First]+" "+"[Nickname]"+" "[Last]
The problem is, if [Nickname] isn't filled in, it returns zero results. How do I tell Access that if one of these fields isn't filled in, just return the other two results to this field?