Hello guys,
First of all let me tell you i'm new here and came to get some info and to learn more about access and hope some kind people of the community could answer some of my questions
The thing is that I've got an test on access / Excel course in 1 month and we have to make our own little project but at the same time i had this guy that's working for a fence placing company that asked me if it's possible to make some kind of calculator that could estimate the price needed for the fences when he just inputs the "Length" and "Height" needed.
So i thought to myself why not make my project exactly on this and help this guy make his job easier at the same time, let me explain exactly what info i got and what he needs
Info i got:
1. I can make my own reference for different type of fences
2. I've got around 300 types of different fences
3. I've got the fence Length / Height and Price per Unit
4. There are gates too but that's for later use & he can calculate it by head since it's usually 1-3 gates that are needed
What i need:
1. When he inputs on a calculator that he needs lets say 350 meters of length and 10 meters of height then he gets the answer on which fences he needs and how many fences are needed to get to 350 meters length and 10 meters height and how much this would cost in total
2. When he inputs the "fences reference" and the meters needed he gets the total price (because there are different type of fences so he could choose the fence needed by himself so the computer could calculate if this fence = 1.5 meters and he needs 350 meters this would need "x" amount of fences and this would be "x" amount total price)
So I'm still thinking on how to go around this... but the thing is that with all the things I've done so far or tried out i'm getting fail after fail and i wanted to have your thoughts on the way i could go around this
Thanks for reading and hope you understand everything since English ain't my Mother tongue to start with but if you have any question just ask i'll reply as fast as i can.
Oh and before i forget if you got any useful websites with guides or videos i could watch i'll take it thanks alot!!!