Hi all,
I'm sure I used to be quite good at this but I appear to have forgotten everything :banghead:
I'm having trouble with #Error in a query where I'm trying to bring in the Account Name with the Outcode at the end.
When it errors, I just want the Account Name.
This is what I have so far:
Name: IIf(IsError([Account Name] & " " & [Outcode]),[Account Name],[Account Name] & " " & [Outcode])
thank you
Anthony
I'm sure I used to be quite good at this but I appear to have forgotten everything :banghead:
I'm having trouble with #Error in a query where I'm trying to bring in the Account Name with the Outcode at the end.
When it errors, I just want the Account Name.
This is what I have so far:
Name: IIf(IsError([Account Name] & " " & [Outcode]),[Account Name],[Account Name] & " " & [Outcode])
thank you
Anthony
IIf(IsError(
0 commentaires:
Enregistrer un commentaire