AnsweredAssumed Answered

connecting transactions totals table to a monthly report table

Question asked by user19036 on Aug 5, 2013
Latest reply on Aug 7, 2013 by mikebeargie

TABLE A (Transactions) is a table of transactions, one record for each transactions, multiple transactions throughout the month.


In TABLE B (Monthly Report), I have a monthly report of the information (inculding totals) of those transactions. One record for each Month. This information comes from another source, NOT the transactions themselves.


My wish is to have a field in TABLE B (Monthly Report) that summarizes the monthly transactions total in TABLE A (Transactions).


I've tried different things, including creating a field in TABLE A (Transactions) that reduces the time stamp of any transaction to a '2013.05' format, thereby identifying the month that it falls in. Then I have a field in TABLE B (Monthly Report) with the same format, entered manually when I create the record. I'm starting to think this is not the best solution...


Any ideas?


Thanks in advance!!