I am going to try to simplify my question as best as I can.
I am using Access and have a table called 2023. For each row of the table, a participant has a field for their name, and a field for each month of the year. Every month has a different amount. My goal is: Donald received money for the entire year: January: $400.00 February: $380.00 March: $500.00 and so on.... December $1,000.00 Donald ended the year with his December amount equal to $1,000.00. I need to modify the current table called 2023 to reflect Donald's December amount to now be reflected in January, February, March, and so on, so that it is reflected in every single month. Each member has a different amount they ended on in December so I need each individual member to be updated accordingly.
Is this possible to modify data in Access in the table "2023", to update this information back into the same table "2023".
This is my second time submitting this because I think I was a bit confusing in the first question.
Mr. Rost I will literally pay you to help me with this, as I need to do it every year. I am really hoping there is a Macro I can create so I can just click a button at the end of every year.
Juan C Rivera
@Reply 2 years ago
not sure of what you are trying or how you are tying to do. but I will give it a shot. try
Crosstab Sort and Crosstab videos to see if this will give you an idea of how you wish to approach this.
V/r
Juan
Heather MontalbanoOP
@Reply
2 years ago
The problem is that I cannot make a query. I need the data changed on my table. I need the flatview data changed so for each record, the amount thats in their december field carries over to their january field, and february field, and so forth. I have to modify the data on the table itself so i can then create a query based off the NEW data. I wish I was a student so I could post pics.. sorry
Adam Schwanz
@Reply 2 years ago
If you want to pay to have someone do it, look at the Access Developer Network. If you want to use me, my email is on that page, send me an email being as specific as you can with what you want to happen. From your previous post I thought you wanted to make 2024 all match december 2023, but now it looks like you want to go back and change all of 2023s months to match December. Does this apply to all customers at once or just one/specific ones at a time? You can make an update query function for that in a button.Update Queries
Matt Hall
@Reply 2 years ago
As far as I can tell, you need the $1000 amount for Donald copied from December of the 2023 table to every month column, for Donald, in the new table. My response is predicated on that being your desire.
1. Save a back-up copy of your database before altering records.
2. Copy 2023 table and name the NEW copy 2024...or whatever you want.
3. In datasheet view, in 2024 table, right-click and rename the January field to January_old.
4. Now rename the December field to January.
5. Right-click and copy the new January column and paste into the other month columns.
6. When you are done you will need to create a new December field or rename January_old to December and re-arrange fields.
I hope that helps,
Matt
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
