Search results

This is an issue on my end sorry for explaining this poorly, We work with 5 suppliers, who all supply monitors, 3 of them have the same transport cost method (if the total falls between a range) add x, we want to have a database that takes the total cost puts it into that range for each...

It is just one product, between 5 suppliers, The prices are all extremely similar, but their transport costs vary resulting in more cost effective products. We are trying to do make it so all the suppliers fit within a range, So like a supplier which would be based on pallets, converting them...

So is that separate tables? So Product table into product supplier then supplier transport cost etc. Or is this using a specific tool. Secondly, how would one then setup a form to make it user friendly. Thank you.

Yeah that is correct, Cost for decision = base cost +transportation cost So are those 5 listed characteristics are they 5 seperate tables, Ive currently got 3 seperate tables, One for the product (Monitor) with 3 suppliers all in their own seperate tables with their specific ranges. Earlier The...

Product X x 10= 500 so transport cost from one supplier would be 58 then comparing that to the other supplier which would be add 40. So then seeing if lets say product X=35 and Y=55 Would product Y be cheaper because of its cheaper transport cost or would X be cheaper. Just trying to find out...

Hello Hello, thank you for the response, So details! One supplier, has 4 Ranges, If between 0-50 add 10 if between 50-150 add 20 if between 150-1000 add 40 and if between 1000-2000 add 70. Another supplier is 0-250 add 35, 250-1999 add 58 2000-4999 add 120 5000-9999 175 10000-19999 360...

Hello, my main aim, is to be able to take given suppliers delivery cost, which is different depending on which supplier is selected, then a user can input a product choose the supplier and the quantity of products, this will then workout the transport cost and add it to the total, using this the...

Id Love some help on an issue im having, I dont want to be given the answer just some tips. This is my first time using Access. I am trying to make an automated database which when you put in some basic parametres it takes that information and gives you the information you are after. I am trying...