ACCESS HELP

[Buddy]

Hi

I'm trying to find out how make this work.?
I have a shop that make hand rail for apartments, I making a program in
access that I can type in the length of rail I need and it will add up the
( weight, price per foot, and how much metal need ) I understand about
tables and forms but I think this is where Queries come in ( yes I'm new at
this) but I learn fast.? I just need a little understanding what I need to
know and do

any help would help

 

[Joseph Meehan]

If you want to type it in, then that would be a form not a query.

Are you going to be saving any of this information or are you just using
Access to compute the values?

If you want to just computer the values, MS Excel, the spread sheet
program is the better tool.

 

[Buddy]

I will need it to store the info I type in and the values it compute ( if I
can get this to work I will have access do a lot more then add the weight,
like adding up price per foot, and how much steel to order.) and I can make
a shipping ticket , shop order ticket and material cut list,and so on (
balocony rail, stair rail, fences,)

 

[Buddy]

I will need it to store the info I type in and the values it compute ( if I
can get this to work I will have access do a lot more then add the weight,
like adding up price per foot, and how much steel to order.) and I can make
a shipping ticket , shop order ticket and material cut list,and so on (
balocony rail, stair rail, fences,)

 

[Joseph Meehan]

I will need it to store the info I type in and the values it compute ( if
I
can get this to work I will have access do a lot more then add the weight,
like adding up price per foot, and how much steel to order.) and I can
make
a shipping ticket , shop order ticket and material cut list,and so on (
balocony rail, stair rail, fences,)

I suggest putting the formulas in a query then after you have entered
the data (use a form if you like) it will compute the results. You can then
store the results.

Note: Normally it is not good design to store the results of any
calculation where all the data that went into the calculation are also
stored as Access works faster at re-computing the results than storing and
retrieving them.