We have an Access Application for Sales in our main office. i've used a frontend/backend approach in this application. We have five remote branch offices, each branch office is responsible in monitoring the sales in the region which was supervised by a sales manager per region. Each branch office has a copy of the Access Application. the top management of the company want to consolidate the sales data into one database to come up a sales report per region and to compare the sales by region.
my problem is how to consolidate the data located in the different branch office.
your help will be appreciated.
my problem is how to consolidate the data located in the different branch office.
your help will be appreciated.