Display columns Data in one single row

[tasawer]

Hi,

I have mainform with AccidentID linked to subform that has maximum 4-rows of information for each main ID.

Four each row of information, I have:
item-Cost - Discount - Paidyn
items are:
Storage
Recovery
Referral
Hire

Database works fine as Mainform/Subform structure.

so that I can easuly browse through all bits of information, what I wish to have done, is display all four bits of information in one row of datasheet view..

e.g.
AcidentID - item1 cost1 discount1 paidyn1 item2 cost2....paidyn 4

is this possible and if so how?

Thanks in advance