Merging 2 records into 1 record

[macca]

Can anyone help me with this one ?

Attached is a spreadsheet showing data from an Access table. The Ivd Id field has produced 2 records.

I need to show this detail on 1 row. I have tried using crosstab queries to do this, but there a lot more fields than the ones shown and the processing required is too much.

I have colour coded the data on the spreadsheet to show the 2 records for Ivd Id =36926 (rows 2 and 3 on the spreadsheet), and how they would need to appear in an access query or table (row 16 on the spreadsheet)

 

[cross5900]

Try seeing if this works FieldName: [Subject1]&[Subject2] -- this should combine both subjects into one.

I am assuming this is what you wanted.

 

[macca]

No

If you look at the spreadsheet you will see the data is in sperate fields. All you are suggesting is concatenating the fields.

Never mind I have worked it out anyway

 

[cross5900]

Sorry, took a stab without looking at the spreadsheet since I was at work. Glad you got it though.