I have about 400 items that go on sale each month. The prices come from my major supplier.
I put the prices, dates and sale type into the Item table with a query, but I haven't been able to figure out how to round these prices the the nearest .09.
When I try to use the Inventory Wizard, there is an option to change sale prices, but this assigns a sale price to every item in the database. I want only to modify the subset of items I'm putting on sale.
Any suggestions on how to do this?
Thanks very much