query data to update table

[smiller]

I would like to run a query and then be able to edit that information. I want the data I change to be put into the table the info was gathered from. Right now when I edit the query data it only saves it there, not on the other table. I tried to do the copy to table but the original table was going to be erased and then written over. What should I do? thanks

 

[KenHigg]

a. When you run a query the data always comes from a table a some point
b. If you edit this data in the query view, you are editing the data in the table it came from.

Given these facts, your problem as described becomes a bit fuzzy... ??

 

[smiller]

I got it, thanks. I was mismatching my data so it didn't seem like it was changing. I retested it and it works Sorry this is my first time using access and I am really bad at it

 

[KenHigg]

No problem - Welcome to the forum