using an update query with a summed query

[newnoviceuser]

I have a transaction database called rtrans that has codes and amounts
the codes determine what type of expense it is.
I have a second database called chart that im suppose to put the totals in. I have a query that groups by code and sums them up just like I want.

what i want to do is make an update query that takes the summed total in code 101 and store it in code 101 in chart.

 

[dhookom]

An Access query doesn't allow you to update records when one of the recordsets is a totals query. I'm not sure why you need to store values that can be calculated.

You may be able to replace the totals query with a domain aggregate function.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]