Recent content by MrPete

Mmmm... well, that query does not work, because it counts the wrong thing... but thanks anyway. The *concept* is sound. So, I made a detail query that produces per-account data (summing all sub-account elements, and then another summary query that groups the detail query appropriately. All...

First time post here. I've got what I thought was a relatively simple query... but not so much. How do I fix this? I have organization, account and investment tables. Multiple inv's per acct, multiple accts per org. Org's have names, accts (aka funds) have status and type, and investments...