By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,778 Members | 1,318 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,778 IT Pros & Developers. It's quick & easy.

Cant Update Recordset

P: n/a
I am trying to make a finances database. I have a master table which
contains transaction header info and then a line details table. What i
want is to make a reconcile query where i can see simply the date,
account and posted (boolean field) from the transaction table and then
a subquery with the total off all the line details for the transaction.
this in itself is easy to set up. However I can not check if it is
posted? If i go back to the subquery and ungroup it i can. But when i
sum it so that i can see the total of the transaction so that it
matches the bank statement it wont let me update it. How do i solve
this?

May 30 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
You may not be able to do it quite this way. You cannot update a row in a
grouping/summing query. By definition, you are not looking are a single
identifiable data row in a grouping query. You are looking at one summary
row on each line that could represent any number of lower-level data rows.

Sadly, when another query includes a reference to such a query, the new
query also becomes non-updatable as well.

There are quite a few ways to go at this. Are you constrained to queries
for any reason, or can you branch out to forms for these tasks?
May 30 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.