Update Query

  • Thread starter Thread starter RandyB
  • Start date Start date
R

RandyB

I have created a small database to help me invoive sales.
The DB has two tables (orders) (Unit price) I have created
an update query to update the orders table for total Sale
amount. It calculates Unit Price x Qty and puts the total
in the Orders table. My problem is that the update query
only updates 48 of 61 records. It will not even update any
new records I put in. I cannot find anything different
with each record. Why will the update query only update
part of the table?
 
Could be a problem with how your query is written.
Exactly what statement is in the UPDATE line of your query?
What EXACTLY is the formula you typed there?
 
Here is what I have in the UpDate Query

Field: Line Total
Table: Orders
UpDate To: [unit price]*[QTY]
Criteria:
or:

I am now updating 50 records out of 67...!

thanks
 
Back
Top