Hi All.
I created query where Location field should be display value based on some conditions. For that I specified for that field nested IIF statement:
As a result I would like to get:
1. [qLocations].[Wing] > " " return value is correct
2. [qLocations].[Wing] = " " I would like to get concatenation of [qLocations].[Facility] & [qLocations].[Building] & [qLocations].[Floor] & "-" & [qLocations].[Room] value but actually result is empty
3. If all concatenated values is null I'm expecting to get empty result.
How to modify the code to get values based on those conditions?
Thanks
I created query where Location field should be display value based on some conditions. For that I specified for that field nested IIF statement:
SQL:
Location: IIf([qLocations].[Wing] > " ", [qLocations].[Facility] & " " & [qLocations].[Building] & " " & [qLocations].[Wing] & [qLocations].[Floor] & "-" & [qLocations].[Room], IIf([qLocations].[Wing] = " ", [qLocations].[Facility] & [qLocations].[Building] & [qLocations].[Floor] & "-" & [qLocations].[Room], ""))
1. [qLocations].[Wing] > " " return value is correct
2. [qLocations].[Wing] = " " I would like to get concatenation of [qLocations].[Facility] & [qLocations].[Building] & [qLocations].[Floor] & "-" & [qLocations].[Room] value but actually result is empty
3. If all concatenated values is null I'm expecting to get empty result.
How to modify the code to get values based on those conditions?
Thanks
Last edited: