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...
Thanks in advance!!