By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,475 Members | 1,361 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,475 IT Pros & Developers. It's quick & easy.

Display columns Data in one single row

100+
P: 106
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....paidyn4

is this possible and if so how?

Thanks in advance
Mar 30 '10 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.