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

i would have a form with 12 sub forms each with their own query or sql statement with different criteria for each. or you could use a listbox and have it populated using the SQL Dlookup command.

Please post some sample data.

It can be done using a report. Do you want to enter a date range say 30 days and display the appointments or are you happy with just a six day date range?

Hi,
here is some sample data..
I am happy with just a six day date range because every week we need to take list..
Name, Address, InterviewDate, Shift, Status
Safwan,efefef,16/02/2010, AM,IN PROGRESS
Rabaca,jetair,15/02/2010, PM,IN PROGRESS
Ruby,4565,25/02/2010, AM,IN PROGRESS
JACOB,992,17/02/2010, AM,IN PROGRESS
JENNIFER,STREET NO.1, 16/02/2010,AM, IN PROGRESS
Mathews,Jabbar Road, 19/02/2010, AM, In progress
Sudesh, Cabbern park, 20/02/2010, PM, In progress
Bobban, Road no.2, 15/02/2010, PM, In Progress
Lissuy, Brigade road, 17/02/2010, AM, In Progress
Manoj, P.O. Box 995, 18/02/2010, AM, In Progress
Roy,efefef,17/02/2010, PM,IN PROGRESS
Moosai,Safari,15/02/2010, AM,IN PROGRESS
Sundar,4565,16/02/2010, PM,IN PROGRESS
James,9923,15/02/2010, AM,IN PROGRESS
Justin,STREET NO.1, 21/02/2010,PM, IN PROGRESS
Eliyas M,Main Road, 19/02/2010, AM, In progress
Jacob man, Cabbern park, 19/02/2010, PM, In progress
Bose, Road no.2, 17/02/2010, PM, In Progress
Jessica, Brigade road, 18/02/2010, PM, In Progress
Sreedhar, P.O. Box 992, 17/02/2010, AM, In Progress

Regards,
Aliyan

I wouldn't necessarily concentrate on specifically using arrays. You can utilize a good combination of queries or a make-table query to achieve your results. How you setup those queries depends on how you've setup the fields.

Unzip the attached file note this was created using Access 2003. This database has the sample data supplied as per your previous post.

Open form frm_rpt_interview_dates, select the beginning date by highlighting a date on the calendar then click on the beginning date button, do the same for the ending date. Click on Preview and a report will be displayed listing the interviews scheduled for that period. You also have the option to email or print the report.

Thanks a lot my friend..

Aliyan

Thanks a lot my friend..

Aliyan

Nice example poppa smurf.

Do you mind if I post that in the code bank?

You can post it in the Code Bank if you wish.

This was a database that I found in a forum or on the web. I modified the layout to suit the requirements for my work area.