What is an Easy way to create Monthly Reports?

[hnelson]

I am using Access 2000 for a loans database and I want to create an automatic monthly loan report without having to go in and change the date range every month.

I was thinking of using the calendar function on a form so that anyone who wants a report for a specific month can select it and change the query automatically.

I was also going to create day month and year fields in my "loan details" table and using the "date of loan" date field as the control source for the day/month/year fields. This would allow me to do a sort by month or year in the query for the report.

Would this approach work with the calendar?
Is there an easier way to create this type of monthly report?

 

[MichaelRed]

IMHO, you don't need the various dateparts in the db. Just a single date. Use the various attributes of the DatePart function in a query to seperate the date into the parts (Month, year ...).

e.g.:
? DatePart("m", Date())
3
? DatePart("yyyy", Date())
2001

So, just make the Part be like:

MyMnth: DatePart([DateField])
MyYear: DatePart([DateField])

And place criteria in each field. Fill the criteria at run time.


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over