JimboTraveller Posted February 18, 2005 Share Posted February 18, 2005 I'm trying to get my 'Cashflow Table' to display records from an 'Income Table' and an 'Outgoing Table'. How can I set it up so that a 'Transaction Date' column will display dates of both 'Income' and 'Outgoing' in chronological order? Thanks in advance for any suggestions. Link to comment Share on other sites More sharing options...
aaa Posted February 18, 2005 Share Posted February 18, 2005 Creat third tabel with fields: Date, Income, Outgoing. This tabel must contain the date of all year. Then creat relationship on Date to the other two tables-let it be A and B. Then your Income in the third table will be calculation as Sum(A::Amount) and Outgoing will be Sum(B::Amount). Find in this tabel may be slowly, at this case you can by script make Income and Outgoing fields in the third table static fields. Link to comment Share on other sites More sharing options...
comment Posted February 18, 2005 Share Posted February 18, 2005 Perhaps you should consider a single Transactions table, with Income and Expense fields. Should make any kind of reporting much easier. Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Archived
This topic is now archived and is closed to further replies.