Hi,

In my Access database Name, Address, InterviewDate, Shift and Status are some fields..

Every week I need to print a report for next week for the people to be called for interview on the basis of InterviewDate.
When enter a range of date for 6 days, the report should be printed in 6 columns for each day from Monday to Saturday and it should be separated for Morning Shift and Evening Shift.

Can anybody help me make a code for this using arrays?


Best regards,

Aliyan