I have a bunch of Data in a Checkbook register frm/tbl etc. And I realized I have incorrectly attributed some of the transactions to the wrong account.
If i make the changes in the form that I have created it will take forever (sort to transaction account type, select record, select edit record, which I have set up stupidly and it closes the main form to open the edit form, etc etc etc)
so I created a query to select the transactions that need to be changed but It wont let me make the changes in the query.
I used to know and understand this but seem to have lost that knowledge.
how can I create a query to change the data in these transactions
in the image below you can see that most of the Transactions are attributed to the "Chapter" OHSTATE (thats who paid the donation)
and I need to change that to attribute those to the chapters that received the donation like the one that is underlined in red
As always thank you for the help