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

To query subdatasheet/subform

P: 10
Hi all,
I have a table which has a subdatasheet. I need to create the query that will have additional field(s) for each record in sub datasheet. How can I create such a query?

To bring in the actual picture; I have a form frmOrders_Main which is bound to the table tblOrder_Main and it has the following details, OrderID, OrderDate and Customer along with a subform listing all the products with their price for that order. I need to export these via mail merge to a word document. There is no facility to word merge subform. So I decided to extract each record in subform and make a separate field(s) in the resulting query along with OrderID, OrderDate and Customer from main table. Then I will make this query the datasouce for my word document.
My question is is this possible and feasible? If not what is the more feasible way to do it.


Your assistance will be highly appreciated.
Thanks
Jul 15 '08 #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.