MS ACCESS 2000 VBA - Date/Time calculations:

I have two tables: ? Clients attendance ? Clients Client&'s Table Structure: ID, Record Number, Last Name, First Name, Team, Counselor, DOB, Sex, and Intake Client&'s Attendance Table Structure: ID, Date and Record Number. I need to create a MS ACCESS attendance report showing the following for each client : ? First Name ? Last Name ? Counselor ? Team ? Intake date ? Birthday ? Sex ? Age ( i.e.34 years old) ? Record Number ? First visit (i.e. 5/1/01) ? Last visit (i.e. 11/6/02) ? Total number of visits (i.e. 80) ? Number of visits per week (i.e. 3) ? Number of visits per month (.i.e. 22) ? Number of visits per year (i.e. 55) ? Last 5 consecutive visits (i.e. 5/1 to 5/5). ? Each fifth visit date (i.e. 5/3, 5/8, 5/14, 5/19, 5/24, 5/29. 6/3?). ? Time elapsed between consecutive visits if any (i.e. 6 days, 3 months, etc). ? Time elapsed from last consecutive visit (i.e. 7 days). ? Time elapsed from last visit (i.e. 4 days). ? The largest number of consecutive visits achieved (i.e. 25 consecutive visits). ? Dates of largest amount of consecutive visits achieved (i.e. 5/1/02 to 5/25/02). The dates above are only examples. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. ## Platform WINDOWS 98, XP 2000 ## Deadline information Must be complete by 12/1/2002