Using restults from query to update specific field

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I have 2 tables, [adjustments] which has date, and price adjustments, and i
have [work done] which has all of the information that is calculated off of
the quantity entered and using the price adjustments related to the date
entered.

I have a query that shows me all items in [work done] that have a quantity
but no price adjustment (this results when there was no price adjustment
entered for that month). What I am tryint to do is update the price
adjustment that is stored in work done based on the quantity.

What i want to do is update the calculated price adjustment that is in [work
done] based on the results of this query.

So what i'm trying to say is, how do i change a value in a field based on
the result of the query?
 
Just wanted to add that i've been trying to add code into the update field on
the "update query" but i need to have an if statement in there and i'm having
some trouble..
 
Alright.. and turns out i had to use IFF not if.. go figure.

case closed

Steve said:
Just wanted to add that i've been trying to add code into the update field on
the "update query" but i need to have an if statement in there and i'm having
some trouble..

Steve said:
I have 2 tables, [adjustments] which has date, and price adjustments, and i
have [work done] which has all of the information that is calculated off of
the quantity entered and using the price adjustments related to the date
entered.

I have a query that shows me all items in [work done] that have a quantity
but no price adjustment (this results when there was no price adjustment
entered for that month). What I am tryint to do is update the price
adjustment that is stored in work done based on the quantity.

What i want to do is update the calculated price adjustment that is in [work
done] based on the results of this query.

So what i'm trying to say is, how do i change a value in a field based on
the result of the query?
Click to expand...
Click to expand...
 
Back
Top