Removing commas if there is nothing after the field 2

[dinster]

GP_Address: [GP Add1] & ", " & [GP Add2] & ", " & [GP Add3] & ", " & [GP Add4] & ", " & [GP Postode]

i've put that in access query and wanted to know if there is nothing in either field names then do not include the comma.

Is this possible and could someone show me an example


many thanks

 

[VRoscioli]

How about something like:

GP_Address: [GP Add1] 
  & Iif(IsNull([GP Add2]),"",", " & [GP Add2]) 
  & Iif(IsNull([GP Add3]),"",", " & [GP Add3]) 
  & Iif(IsNull([GP Add4]),"",", " & [GP Add4]) 
  & Iif(IsNull([GP Postcode]),"",", " & [GP Postcode])

May need some fiddling to work as you desire.


-V

 

[PHV]

Provided the fields are Null instead of ZeroLength:
GP_Address: [GP Add1] & (", " + [GP Add2]) & (", " + [GP Add3]) & (", " + [GP Add4]) & (", " + [GP Postode])

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886