Hi guys, not sure if this is the correct place or not but i need some help with the following. Its a bit hard to explain but i will try. I want to be able to apply this sum in a form.


Basically this is the data that will be inside a table.
Country | 1st 0.50 kg | Each additional 0.50kg up to 15kg | Each additional 0.50kg up to 25.00kg | Each additional 0.50kg more than 25.00kg |

Germany | £10.00 | £2.00 | £1.50 | £1.00 |



I will then have a form on the front page with these options.


Destination - Drop down box that is linked to the country field
Weight - Weight.
Total - Calculation


I will then want it to work out the calculation for the user. This is an example.


E.G 1: Total Weight = 8KG. This is £10.00 for the first 0.50 and then each 0.50KG up to the total weight at. 15x £2.00 + £10.00 = £40.

E.G 2: Total Weight = 15KG . This is different. This is £10.00 for the first 0.5 and then its the £1.50 for each additional as its over the first bracket it then just takes it from the second and skips the first. so this would be: £1.50 x 15 + £22.50 + £10 = £32.50


I will obviously have a different price for every country in the world and every country listed

Looking for help on this please

what part of that do you need help with?

This post was edited by carteblanche on Nov 29 2013 04:03pm

How i would set something like that up. like the calculations and the forms. Im literally learning Access as i go along. its very hard

i'm not familiar with what you mean by "forms". does access come with the framework for it, or are you using something else for the front end (eg: vb, c#, java, php, etc)? i assume you dont have to write the logic and build the message via sql, and you just need to fetch the data in sql.

By Forms its like the front end. But yes i can't get my head around the logic. It needs to be something like'

If under 15kg use column X. if under 25 use column X. if over 25 use column X

Then the sum will come in once it will grab the correct set of data

This post was edited by demonblade05 on Nov 29 2013 04:24pm

if those column headers are all hard-coded and do not vary by country, then just hard code the strings, then conditionally add them in based on the weight

the columns all stay the same. How does the calculation work for bringing out the costs with the times?

not sure what you're asking. are you talking about messageend in my code?

Well what did you mean by hard coded ?

Still needing help please