Access 365 Report use nickname if exist instead of 1st name

[renigar]

We have a simple employee database, 1 table, names, addresses. work cell phone number, etc. A new cell phone list is distributed whenever there is a change. Some employees are widely known by a nickname which we have a field for. When printing the report I would like to replace the first name with the nickname if it exist. In excel I would use a formula like this: If(nickname<>"",nickname,first name). How/where do I do this in access?
I'm new to access so thanks in advance.

 

[dhookom]

Access has a Nz() funtion.

=Nz([NickName],[First Name])

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[renigar]

Thanks dhookom,

I've been googling the function and the pages tell you the syntax but don't tell you where you use it. In a query, in the report? Could you please provide a little detail or direction.

 

[dhookom]

Use it as the control source of a text box. The name of the text box can’t be the name of a field.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[renigar]

After a little more research and some YouTube videos I have figured it out.

Thanks for the initial push.
renigar