Alternative to subform

[theatreman]

I have a form that has several data items that can have more than one answer (usually no more than two or three) I have used subforms but wonder if there is another way of doing it. I would quite like to be able to output a single row of data for each record at the moment there can be three or four rows with the basic info repeated each time. Any ideas?

 

[Shadez]

Write a query that compresses the data into 1 row then build a form from the query