Loop through Recordsetclone set focus to each record

[arnelgp]

Thanks arnelgp for your input, I had thought about a query but wasn't quite sure how to go about it. I am a little confused though, when you say it doesn't require maintaining inventory table, but then at end of query I am assuming this goes to Quantity_on_Hand in table, can you explain that a little better, sorry for my ignorance I am on a crash course here but learning more each day.

it doesn't go (update the any table) to Inventory table.
Quantity_On_Hand on the query is a Calculated Column.

see attached. see Table1, then open Query1.
view Query1 in design view.