Query Output To Update Table

[chathag]

I have two tables, A and B
I currently run an update query which updates table B with data from table A. Table A is constructed using a make table query.
The question I have is would it be possible to update a table directly using the output from a query?
If so a point in the right direction would be appreciated.

 

[namliam]

Yes you can do a query upon query upon query to update a table...

Updating a table though in general is NOT a sign of a well developed database.
Updates are only required upon changes, thus you are propagating thus either storing the same information twice or making totals which should be calculated on the fly.

 

[chathag]

The purpose of the table is to generate a chart.

I have 4 queries returning information for a line chart, putting the information into a table has been the easiest way of producing the chart.

 

[chathag]

So could you tell me the syntax for a query output to directly update a table please.

 

[namliam]

To update a table you make an "Update" query... Simply change the settings in the query options.

Update queries can be a bit tricky though...

 

[Atomic Shrimp]

In general, anything you can do in Access with a table, you can also do with a query - so instead of having an Update query updating a table with a form/report/chart pointing at the updated table, you can just point the form/report/chart directly at a Select query, as if it were a table - and access will run the query on demand.