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

    connecting transactions totals table to a monthly report table

    user19036

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

       

      Darryl