andrewhh82
MIS
I am building a Access 2000 database that tracks classes attended by people in my group. i have a table for attendance with the date they attended as field (mm/dd/yyyy). I need to print reports by Fiscal Month (ie. Fiscal Month 9 includes 10/1/05 - 10/31/05) My database currently is simple with 3 tables Employees, Events, and Attendance. I thought of making some type of table with Fiscal month and year but doesn't seem to work out. I don't want to enter the fiscal month and year for every attendance record when i have actual date attended. Any help would be great, i am a novice.