P
programmingrookie
I have a table which includes a "reportdate" column and a "balance" column.
Each month may have several reports, but always one on the final day of the
month. I want to create a query to use as a base of an Access report that
provides only the balances from the previous month's final day balance
report, and disregards any other balance reports for that month. For
example, on August 1 I would like to pull the July 31 balances.
Any ideas?
Each month may have several reports, but always one on the final day of the
month. I want to create a query to use as a base of an Access report that
provides only the balances from the previous month's final day balance
report, and disregards any other balance reports for that month. For
example, on August 1 I would like to pull the July 31 balances.
Any ideas?