Building a sort of accounts package that can be controlled and reported via the web. I am trying to build a trial balance page that will total all the values of filed A and total all the values in field B. Then it will take total B from total A. I need it to display the result opposite the account name in the repeat region section.

What I was thinking was a SUM(tbl_field) in the SQL which works but I need it to filter for each of the different account names. So how do I have it automatically check for account name "bank", display the result and then check for account name "sales" and so on.

Any suggestions??



_________________________
David Behan - www.bmor.com