Hi, I understand there are some parts to this covered already in this forum however i've found it impossible to pull together the complete solution.
I have an access web app created using multiple tables / forms in order to input the information. This ranges from Customer details - Sales Pipeline - Products - Tasks - Employees.
The data for product sales projections is inputted into the products section of the document. The project title for here is the same project title for in the sales pipeline.
What i need to be able to do is by using the most recent product information, based on whether RFI, RFQ, 2nd Round etc, get the sum of all the volumes and totals of the products and projections.
This information then needs to automatically input itself into the sales pipeline part of the document.
So basically.... help I feel like i'm smashing my head into brick wall with this one.
I have an access web app created using multiple tables / forms in order to input the information. This ranges from Customer details - Sales Pipeline - Products - Tasks - Employees.
The data for product sales projections is inputted into the products section of the document. The project title for here is the same project title for in the sales pipeline.
What i need to be able to do is by using the most recent product information, based on whether RFI, RFQ, 2nd Round etc, get the sum of all the volumes and totals of the products and projections.
This information then needs to automatically input itself into the sales pipeline part of the document.
So basically.... help I feel like i'm smashing my head into brick wall with this one.
