I am fairly new to Access and I have a complicated query that I am using for order processing. Basically I have a field [BaseStyle] and each basestyle has a prices associated with it. What I want to do is when a person selects from the drop down table the next field [BasePrice] and the [AssemblyParatsPice] will be also filled in on the form. The three fields associated with this one table are [BaseStyle], [BasePrice] and [AssemblyPrice]. The BasePrice table:
BaseStyle BasePrice AssemblyPartsPrice
Single hole-wide $1.00 $1.35
Single hole-round $1.00 0.8
2 hole base-wide $1.50 $1.50
2 hole base-round $1.50 0.85
3 hole base-wide $2.00 $1.50
3 hole base-round $2.00 $1.00
2 column $4.00 $1.70
3 post $6.50 $3.25
4 post $6.75 $4.50
Not even sure where to start. I am trying to automate my son's business and he builds trophy's upon requests. After all the fields are filled in I will be calculating all the prices to come up with total cost of the trophy.
If anyone can help me I sure would appreciate it. I can attached the whole spread sheet if if would be helpful.
Thanks so much
s
BaseStyle BasePrice AssemblyPartsPrice
Single hole-wide $1.00 $1.35
Single hole-round $1.00 0.8
2 hole base-wide $1.50 $1.50
2 hole base-round $1.50 0.85
3 hole base-wide $2.00 $1.50
3 hole base-round $2.00 $1.00
2 column $4.00 $1.70
3 post $6.50 $3.25
4 post $6.75 $4.50
Not even sure where to start. I am trying to automate my son's business and he builds trophy's upon requests. After all the fields are filled in I will be calculating all the prices to come up with total cost of the trophy.
If anyone can help me I sure would appreciate it. I can attached the whole spread sheet if if would be helpful.
Thanks so much
s
