basically i have a database in access. but i need it to do some excel stuff. i have a column 'total 1', 'total 2', 'total price', and 'vat'
what i need is for 'total price' to add total 1 and 2 together. vat needs to take number in total price and -15%. any ideas on this?
and no, this cant be done in excel. just if this doesnt work ill have to do the working out seperatly
also, i have made a form to enter date etc. its using justified view. what i want to be able to do is type the reference number in that box and for it to go to that record, not change the currect record. any ideas? its already set up as autonumber and indexed with no duplicates
what i need is for 'total price' to add total 1 and 2 together. vat needs to take number in total price and -15%. any ideas on this?
and no, this cant be done in excel. just if this doesnt work ill have to do the working out seperatly
also, i have made a form to enter date etc. its using justified view. what i want to be able to do is type the reference number in that box and for it to go to that record, not change the currect record. any ideas? its already set up as autonumber and indexed with no duplicates