Search results

Hi [arnelgp]: I will try it. Thanks. [gemma-the-husky]: There is already a productionorder-salesorder junction table. See post #3. [jdraw]: As I said this system and business model was already in place and I am sure that it would be more difficult to change the model for this query that runs...

[gemma-the-husky] the way the factory works is that customer orders are accumulated and a production order is scheduled to cover these orders. There is never a deficit, always a surplus that goes to the stock. That's the way the company works, and the system was built to support this. I am...

Hi gemma-the-husky you are right that customer orders are not part of a production order. That's why they are in separate tables. However we need a report (export to Excel) that will combine the Production Order info with the related customer orders for scheduling purposes. Based on this...

Hi arnelgp, I am not sure how this will help. The tables are linked to the FE. Do you mean that by creating and instance of the BE to the FE, will result in running this query faster? Marios

Hi, thanks for replying. Of course I consider joining the tables, the problem is that I want one row for each production order and there are many customer orders for the specific production order. The function basically takes all the customer orders (name,date,qty) concatenate them and put them...

Hi, sorry for not being clear enough. Find attached the relationships schema. See below the qry: SELECT tblProductionOrder.prod_ID AS ID, tblProductionOrder.prod_proCode AS Code, tblProducts.pro_Description, GetMoldStatusExport([prod_MoldCode]) AS MoldStatus...

Hi all, a rather basic problem I guess but I could not find something to optimize this "common type" of queries. For my app, I have to export certain data from an Access DB to an Excel file. I am doing this with TransferSpreasheet. The query must compile data from a Master table that includes...

Hi all, first time here. Seems a great forum. I am a junior developer and would like to leverage my Access knowledge. Marios