A/R aging

[Guest]

I'm relatively new to Access so please bear w/me! We need to develop an
aging report for our accounts receivable. The database has fields:
date
charges
payments
balance
account #
We run our monthly statements from this table, using data query. New data
is imported once a month.
Does anyone have a simple method of creating aging reports with buckets of
0-30 days, 31-60 days, etc?
Thanks for your help

 

[[MVP] S.Clark]

Create a query for each aging group(0-30, 31-60, etc). Append the results
to a table. Base a report on the table.

Use a macro to run all the queries and the report with a single click.