Hello all,
I'm kinda new to Access, and I've started a new job wherein I've inherited an Access database (with a bunch of tables, queries etc.) from the person who retired. This said person probably didn't know Excel well enough, and therefore decided to use Access to do something that could very easily have been done in Excel. My intention obviously is to scrap Access from the equation, and move everything to Excel (where it belongs).
So there's this one query (SQL statement listed below) which has a plus sign (+) after the "SET [TableName].[FieldName] =" portion of the SQL statement, and I have no idea what that + sign is doing/used for.
Would appreciate if someone could explain its use/logic to me...since I've never used/seen something like that used before.
Code:
UPDATE [TableName]
SET [TableName].[FieldName] = +[Employee Information]![Do Not Use Business Group], [Employee Information].[Roll Up Org Level 2] =
IIf([Employee Information]![Do Not Use Business Unit]<>"unassigned",[Employee Information]![Do Not Use Business Unit],(IIf([Employee Information]![Do Not Use Division]<>"unassigned",[Employee Information]![Do Not Use Division],(IIf([Employee Information]![Do Not Use Sub Division]<>"unassigned",[Employee Information]![Do Not Use Sub Division],IIf([Employee Information]![Department]<>"unassigned",[Employee Information ]![Department],IIf([Employee Information]![Section]<>"Unassigned",[Employee Information]![Section],"")))))));
Thanks.