Hi,
I have a database with all the COGS(Cost of goods sold) for our ITEMS, a few times each year we do a update based on purchase prices. (not always all)
So in Table A we have the total list of items with cogs, and in table B we have the list of items that has had it's price increased or decreased.
Common key in the tables are the item number.
I then thought I could do an update query that would go something like this.(not trying to write the actual code, just how I think)
Update tableA.COGS
With tableB.COGS
Where tableA.ITEMNUMBER = tableB.ITEMNUMBER
Any help would be appreciated.
//Cow