Calculating a Recurring Expense

[JCrowe]

Using Access 2000 I have created a database to track
expenses for a library. I have all of the annual charges
for magazines showing in my query correctly and on the
report. However, my problem is getting the query/report to
track recurring monthly charges. For example, every month
they pay for online service usage such as Lexis-Nexis. I
need to be able to project that expense through out the
year and have it show on my report.

I set up the database table with a "Monthly Expense" to
track the cost...however, when a report is run I need it
to show for the time period the report is for. For
example, if I run a report for Jan 1, 2004 thru March 30,
2004 I need that expense to show in each month...right now
it only shows in January (NextBillCycle) Column.

Thanks for the help !
JCrowe

 

[Shao]

Try using a query with dates as criteria. Build a form or
report using that query and the database should filter the
info.