Update Query Question

  • Thread starter Thread starter Paul Axelrod
  • Start date Start date
P

Paul Axelrod

I am a relatively new user of Access. I created a multitable database
to track orders my department places. We can then send a regular
report to central purchasing. I have created a form, wherein I enter
quantity and unit price, which is written to a table. I have a
control which then calculates the extended price for each line item in
the order, and then created a query to calculate the total order
price, which is displayed in another control at the bottom.
My supervisor would prefer that I store all the extended prices in a
table, which I dont feel is necessary, but what he wants, he gets.
Someone suggested that I might beable to get the values in the
calculated control written to a table field using an update query but
I cant seem to get it to work.
Thanks for amy input.

Paul
 
Storing extended prices in a table is normally not a prudent thing to do,
unless there is some time-sensitive info that needs to be stored because the
underlying data might change (the price for example if you pull that from a
table that can be updated). But if you're already storing the price and
quantity, storing the extended quantity is just not necessary; and may lead
to discrepancies in the data should someone change a quantity and then not
update the extended price value.

That said, to put the extended value in a table likely would be better done
by an append query. I assume that this extended price table contains two or
three fields:
field1 order number/ID (likely a/the primary key)
field2 part number/ID (likely a composite primary key with
field1)
field3 extended price

Run an append query that puts a new record into this table.
 
Back
Top