TattyDon Posted May 1, 2009 Share Posted May 1, 2009 Hi, I'm not sure whether this is the right forum for this so apologies if not. I have been designing a database for a while now and it's fairly complex but since I am self taught, I am sure that I am using bad techniques. I have one table which lists all my financial transactions. Fields include: Financial Year, Account ID, description, amount. To work out how much i have left in each acount I do the following. Run a script to identify how many accounts are presently used For each account (loop) load a layout showing transactions against that account so that I can get the total amount. Add total amount to a running total End loop Sometimes this process gets even more complex if I need to get a total by account for each financial year or something. So my question is whether there is an easier way of getting totals like this? In the above example, it loads 7 layouts (one for each account)plus the original to identify the number of accounts to get the totals for each account. I am also using go to related record type searches (with individual tables) rather than the perform find function - Anyone know whether that is also a mistake/ I guess alot of us self teachers find ways of doing something and just do it when there might be a much faster way of achieving it... Cheers Tatty Link to comment Share on other sites More sharing options...
bcooney Posted May 1, 2009 Share Posted May 1, 2009 Are you familiar with subsummary reports? Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5446 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now