is access capable of building a cost calculator?

[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?

 

[John... Visio MVP]

Hello Ivory!

I provide help with Access, Excel and Word applications for a very
reasonable fee. I specialize in special projects like yours. I would like
to offer to work with you to create the cost calculator you want in
Access. Contact me if you want to work together.

Steve
(e-mail address removed)

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

-- This post was shortened, not to show a little respect to stevie, but in
response to a public request made by John Vinson. I tend to show stevie as
little respect as possible.

John... Visio MVP

 

[Philip Herlihy]

Hello Ivory!

I provide help with Access, Excel and Word applications for a very
reasonable fee. I specialize in special projects like yours. I would like to
offer to work with you to create the cost calculator you want in Access.
Contact me if you want to work together.

Steve
(e-mail address removed)

http://home.tiscali.nl/arracom/whoissteve.html

Shamelessly violates the group's charter - the only one who does this -
and he's not that good.

PH