Dear Forum Members,
I'm working for a manufacturing company and we have an on-going problem with the consistent arduousness of trying to find the best price for our transporting costs.
We have 2 suppliers both with their own prices, switching between these each time takes a lot of time and can lead to mistakes sometimes.
I want to create a form in access that contains the data of which countries we ship to (and have data for from the transport companies), the weight you want to ship it at, the postal codes that you want to ship it to and then it should display both prices.
I have assembled all the data in the database with the prices of each and such, but I am getting in a huge mess not knowing where to start and how to link everything.
I was rethinking the concept and might want to use access in combination with excel sheets that have all the data, because excel is easier to edit.
Qpido
I'm working for a manufacturing company and we have an on-going problem with the consistent arduousness of trying to find the best price for our transporting costs.
We have 2 suppliers both with their own prices, switching between these each time takes a lot of time and can lead to mistakes sometimes.
I want to create a form in access that contains the data of which countries we ship to (and have data for from the transport companies), the weight you want to ship it at, the postal codes that you want to ship it to and then it should display both prices.
I have assembled all the data in the database with the prices of each and such, but I am getting in a huge mess not knowing where to start and how to link everything.
I was rethinking the concept and might want to use access in combination with excel sheets that have all the data, because excel is easier to edit.
Qpido
Last edited by a moderator: