Why are you not linking on the PK field BankAccountID? The queries should include that field.
I don't understand why you would get that error. Is this just a SELECT query?
Why is there a BeginningBalance field? Beginning account 'balance' should just be a deposit transaction record.
If you want to provide db for analysis, follow instructions at bottom of my post.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Sorry it took so long for me to respond. The holidays were super busy, then year-end created a hectic schedule as well.
I've attached the db for analysis.
Thanks very much!
Doug
I still think the aggregate queries should group on the AccountID instead of name. Don't include the REF_BankAccounts table in the aggregate queries.. Then join the aggregate queries to REF_BankAccounts on the ID fields.
I changed the Currency fields to Number (double) type and removed Currency formatting and changed the aggregate queries to group by account ID fields and linked on ID fields. Qry_All_Balances now works.
I never use Currency type and I never set formatting in tables.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.