12 Replies Latest reply on Aug 7, 2013 4:56 AM by mikebeargie

    connecting transactions totals table to a monthly report table


      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!!