String with IIf statements

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I get rid of an extra space in the string below if [HighlyFigured] or
[HighlyFiguredCurly] both equal "No"

=IIf([CboDetailCategory]=1,[SheetThickness] & " " & [SheetSize] & " " &
[Cut] & " " & IIf([HighlyFigured]=Yes,"Highly Figured") &
IIf([HighlyFiguredCurly]=Yes,"Highly Figured Curly") & " " & [Specie]

Thank you in advance.
 
How do I get rid of an extra space in the string below if [HighlyFigured] or
[HighlyFiguredCurly] both equal "No"

=IIf([CboDetailCategory]=1,[SheetThickness] & " " & [SheetSize] & " " &
[Cut] & " " & IIf([HighlyFigured]=Yes,"Highly Figured") &
IIf([HighlyFiguredCurly]=Yes,"Highly Figured Curly") & " " & [Specie]

Thank you in advance.
Click to expand...

add the last " " to the conditions like:

IIf([HighlyFigured]=Yes,"Highly Figured ") &
IIf([HighlyFiguredCurly]=Yes,"Highly Figured Curly ") & [Specie]
 
Thank you very much.
Matt

Andi Mayer said:
How do I get rid of an extra space in the string below if [HighlyFigured] or
[HighlyFiguredCurly] both equal "No"

=IIf([CboDetailCategory]=1,[SheetThickness] & " " & [SheetSize] & " " &
[Cut] & " " & IIf([HighlyFigured]=Yes,"Highly Figured") &
IIf([HighlyFiguredCurly]=Yes,"Highly Figured Curly") & " " & [Specie]

Thank you in advance.
Click to expand...

add the last " " to the conditions like:

IIf([HighlyFigured]=Yes,"Highly Figured ") &
IIf([HighlyFiguredCurly]=Yes,"Highly Figured Curly ") & [Specie]
Click to expand...
 
Back
Top