I have a set of data that includes one table with transactions, and another that will be a sort-of summary table. The summary table has fields in it for various types of transactions. i would like to run an 'update' query that goes through all of the transaction records, and updates the appropriate field in the summary records......determining which field to update based upon the value of a field in the transaction table (the transaction type). I have MS Access 2010, but also have 2003 & 2007 if necessary.
Is this possible......JUST as an Access "Query" ?
If not, can it be written in VB code or SQL code ?