I have a table Products consisting of the following fields :-
ProductID, ProductName, PriceLevel, UnitPrice
and a query which returns all products with a specific PriceLevel.
What I would like to do is allow the user to copy all products at one
price level returned in the query and add them to the the Products
table with another price level. For example if the user chose 1 and 3,
it would select all products with PriceLevel 1 add them to the
Products table and update their PriceLevel to 3.
I am no expert when it comes to Access but my inclination tells me
that this would be done with code. I would like advice on the code /
query necessary to perform this operation.
Thanks in advance for your help