Simple form addition problem

[BuckRabbit]

Hi I realise this would be a simple question to someone with experience, but I am quite new to Access so please be gentle ...lol

I have a table in which I have three fields, #1 purchase price, #2 postage & packaging cost, and #3 total cost. Piece of piss in
Excel to do this, but how do I go about adding the input value of both purchase price and packaging cost together so they appear
in the total cost field?

All help is appreciated
Cheers
Buck

 

[Guest]

Hi Buck

Simple answer is - you don't. Of course you "can" store a calculated field
in a table but what would be the point. You can view, print, etc the results
at any time so storing the result of a calculation would just be a waste of
disk space.

Create a query based on your table and ensure that the table is in the
design grid.

If you bring each of the fields into the query then add a new column and
insert this
TotalCost:[purchase price]+[postage & packaging cost]

Even this will take up disk space that is not really needed so if you don't
need the fields for another application - for a form, report, ect. If this
is the case use this

TotalCost:[TableName]![ purchase price] + [TableName]![ postage & packaging
cost ]

Of course you would need to use the actual fields name of postage &
packaging cost and purchase price in the calculated field.

Hope this helps