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
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