Turn query into table

[mp3909]

I have a problem.
I have a query that is built by two underlying tables.
I need to make a lot of amendments to the values in this query across different fields.
I can do this by using the update statement but the problem is, my application is going to be used by someone who has no experience in Access. So the only reasonable way that can amend the values in this query is either by looking at the query result, double clicking on the cell in the table and manually type the new value.


But the problem is, this is a query so modifications are not possible in this manner unless through SQL update.
Also, the nature of the values that needs changing is dynamic in terms of the number of values that need changing, not static and it’s also up to the user discretion if he/she feels like it is reasonable to change it.

I believe the best way to do this is if it is possible to somehow convert the query result into a table so that you can change the values?

[JoeM]

You can use a Make Table Query to create a Table from Query results.
See: https://support.office.com/en-us/art...4-e21ad0a94f1b

[Micron]

Sounds to me like you should be basing a form on this query (assuming you can edit the query now). Making a table seems like an unnecessary step in that case. Then what? You have to create another query to update the data based on this new table? I don't see how having this table eliminates the need for picking and choosing fields in a query to make it in the first place.

You said there were lots of fields. You didn't say if there were lots of separate updates. If many separate updates I think that just makes the situation worse when it comes to creating a new table. Why not just use a form and either a) directly edit the data if it's updatable or b) have the form unbound and create the sql in vba based on which fields have data? Using a form is more user friendly than getting someone to monkey with query design, IMHO.