My dad has just started his own business supplying cleaning chemicals to restaurants etc. When he visits somewhere and they want to buy some chemicals, he gives them a rough estimate and he then makes a formal quote when he gets home.
At the moment, he is having to do the quotes manually. He has all the product info in an excel spreadsheet and I was wondering if there is any way to automate the process of creating a quote somewhat. An example of a quote is below.
I was thinking of putting all the product info into a database and using Acess forms and reports to fill in the product info part of the quote. The only thing is, the prices of products change depending on how much is ordered and other factors. Is there any way to do this? I did Access in school a while ago but cant really remember much of it.
edit:
oops I forgot a big part of it.
My dad wants to have a list of all the products he sells, and checkboxes beside each product. He wants to be able to check off a load of products and have the program generate a preliminary quote with the info filled in, and have the price field editable. Then if the price field is changed, the price per litre field changes.
TIA


LinkBack URL
About LinkBacks
Reply With Quote
