Thanks Jeremy,

It puts me on the right track, but how do I get the data into one

recordset?

I now have the following:

Select Distinct AttributeID,

CASE dbo.QIMS_FORMS_INSTANCE_DATA.ColumnID WHEN 1 THEN

dbo.QIMS_FORMS_INSTANCE_DATA.Data End AS Target,

CASE dbo.QIMS_FORMS_INSTANCE_DATA.ColumnID WHEN 2 THEN

dbo.QIMS_FORMS_INSTANCE_DATA.Data End AS LowerLimit,

CASE dbo.QIMS_FORMS_INSTANCE_DATA.ColumnID WHEN 3 THEN

dbo.QIMS_FORMS_INSTANCE_DATA.Data End AS UpperLimit

From dbo.QIMS_FORMS_INSTANCE_DATA

WHERE AttributeID = 1