D
Darby Holmes
I have a table imported from a database - using
the 'linked table' feature - and thus I am unable to
change the values to acronyms. I need to
shorten/abbreviate the values (not column headers) (e.g.
New Requirements needs to be NR) in either the Query or
Report. I tried to use IIF and IF although this hasn't
seem to function despite my best attempt - see below.
Please help.
Thanks
=IIF([Reason]="New Requirements", "NR",IIF([Reason]
="Design Change","DC"),IIF([Reason]="Missed
Requirement","MR"),IIF([Reason]="Implementation
Change","IC"),IIF([Reason]="Requirement
Clarification","RqC"), [Reason]))
the 'linked table' feature - and thus I am unable to
change the values to acronyms. I need to
shorten/abbreviate the values (not column headers) (e.g.
New Requirements needs to be NR) in either the Query or
Report. I tried to use IIF and IF although this hasn't
seem to function despite my best attempt - see below.
Please help.
Thanks
=IIF([Reason]="New Requirements", "NR",IIF([Reason]
="Design Change","DC"),IIF([Reason]="Missed
Requirement","MR"),IIF([Reason]="Implementation
Change","IC"),IIF([Reason]="Requirement
Clarification","RqC"), [Reason]))