Combining three fields into one (Follow-up)

[matterhorn]

Ok i have successfully merged three fields into one using:

SELECT BOM.[ProductID], PROD.ProductDescription + " , " + BOM.Field5 + " , " + BOM.Field6 + " , " + BOM.Field7 as [Description]

but some of the records in the BOM table do not have values for Field6 or Field7. When the query runs it wipes out all of the info in the description field for those records without a value for field 6 or 7. Any ideas on how to preserve the info for records without a value in those fields.

Thanks!!!

 

[PHV]

Use the & operator for concatenation instead of the + one.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244