Recent content by smyck

So I used the Query Wizard to construct this query, so how would I change from DISTINCTROW to a totaling query and group by [account ID]? I changed SQL to this: SELECT DISTINCTROW ChartOfAccounts.[Account ID], ChartOfAccounts.[Account Name], ChartOfAccounts.[Account Type ID]...

I need the other information to build a report later from this query. When I enter in: SELECT DISTINCTROW ChartOfAccounts.[Account ID,sum(TxAmount)] It asks for a parameter value.... Is this how SQL view should look or am I doing something wrong?

Hello, I am in need of some help with designing this query. I need to sum all the transaction amounts according to their account ID so that I only have one line for each account ID showing the total from all the transactions. This is what it looks like in SQL view right now: SELECT DISTINCTROW...