This should be a simple one but I have so far been unsuccessful. In access query, I am using the expression builder within a query to pull information from a table.
FirstName: IIf(Len([tbl_Associate].[NICKNAME])=0,[tbl_Associate].[FIRST_NAME],[tbl_Associate].[NICKNAME])
2 fields - one for First Name and one for nickname. If the nickname is blank display the first name otherwise give me the nickname. When I run the query, the results are only showing the nicknames and all others are blank.
This is a display query only, not updating any tables.