Query, maybe Report, I'm not sure how to express it. lol

[Andrea Buckridge]

I built a Database from scratch that will monitor multiple check registers as well as double entry budgeting accounts. I was able to build simple queries and reports that will allow me to see balances in each separate account according to account type. Now I am trying to build a query and report that will show the over all sums for each account type. For example, adding all the sums of the register accounts together, which is done in each separate summary; but I want register balances, asset balances, expense balances, capital balances and receivable balances on one page. I then need to be able to set it up to compute the sum of the register balance minus the sum of the balances of assets and capital and then to compute the sum of assets and expenses minus the sum of capital and receivable. Thus creating a balance statement. I don't know if anyone can help me on a forum, or if it would be better to try to find someone locally to help.

[June7]

Probably need multiple aggregate queries and then join those aggregate queries to a master dataset or maybe subreports or domain aggregate expressions to pull data from the aggregate queries.

[Andrea Buckridge]

I appreciate your response, but I don't know the lingo, so don't know how to do those specific things. thank you for trying to help though

[June7]

Aggregate query is basic Access functionality. Review http://www.opengatesw.net/ms-access-...ess-Query2.htm