I
ivory_kitten
i currently have a rather complex series of tables in excel and of course a
really rough looking form due to excels limited capabilites, i am interested
to know if i could successfully build a cost calculator in Access to simplify
things.
currently i have one main file with all the costings in it, there are 5
different sheets, with costs from 5 different categories: Linehaul, Vehicle,
Labour, Materials and Storage, most of these contains some base information
and some calculations, some contain 2 different sets of base information and
the same calculations in each column.
then i have the "form" file, which the user uses, they input the parameters
for which they want to produce the costs for, also hidden in this file is a
couple of sheets with formulas and tests to formulate the correct pricing
it's rather complex in excel, and i've never used access before but am
thinking it might be time to learn, is this achievable in access?
really rough looking form due to excels limited capabilites, i am interested
to know if i could successfully build a cost calculator in Access to simplify
things.
currently i have one main file with all the costings in it, there are 5
different sheets, with costs from 5 different categories: Linehaul, Vehicle,
Labour, Materials and Storage, most of these contains some base information
and some calculations, some contain 2 different sets of base information and
the same calculations in each column.
then i have the "form" file, which the user uses, they input the parameters
for which they want to produce the costs for, also hidden in this file is a
couple of sheets with formulas and tests to formulate the correct pricing
it's rather complex in excel, and i've never used access before but am
thinking it might be time to learn, is this achievable in access?