Would a Subquery work here?

[Greg]

Hello all-

Access 2.0 (hopefully something newer soon!)

Trying to update a field in one row, based on criteria in another row.

For example-
PK= (p/n)+(Column)
p/n Column Qty Resale
12345 1 1 $1.95
12345 2 10 $0.00
12345 3 100 $0.00

We need to update row-2 Resale to be 15% off of row-1 Resale.

Any ideas? TIA

 

[Duane Hookom]

I don't usually agree with storing calculated values however, you could
create an update query. Set the Resale to update to:
DLookup("Resale","tblA","Column =" & [Column]-1) * .85
Make sure you don't include the record with a column = 1 in the query.