Ignore sided if certain condition is met 1

[din2005]

Hi all in my query i have a field called sided

Sided: [Side] & " sided"

Now in the side field it will say left or right or sometimes midline.

However it does not make sense if you put down midline sided. Is there anyway to check if it comes up as midline then do not include sided.

e.g

left sided
right sided
midline
right sided

many thanks

 

[Remou]

How about:
[tt]Sided: [Side] & IIf(Trim([Side] & " ")<>"midline"," sided","")[/tt]