Results 1 to 10 of 10
  1. #1
    Join Date
    Feb 2010
    Posts
    4

    Arrow Unanswered: Print records datewise in columns

    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
    Last edited by Aliyan; 02-06-10 at 14:09. Reason: spelling mistakes

  2. #2
    Join Date
    Nov 2009
    Posts
    5
    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.

  3. #3
    Join Date
    Jun 2007
    Location
    Maitland NSW,Australia
    Posts
    388

    Print Records Datewise in Columns

    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?

  4. #4
    Join Date
    Feb 2010
    Posts
    4
    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

  5. #5
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    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.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  6. #6
    Join Date
    Jun 2007
    Location
    Maitland NSW,Australia
    Posts
    388
    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.
    Attached Files Attached Files

  7. #7
    Join Date
    Feb 2010
    Posts
    4
    Thanks a lot my friend..

    Aliyan

  8. #8
    Join Date
    Feb 2010
    Posts
    4
    Thanks a lot my friend..

    Aliyan

  9. #9
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Nice example poppa smurf.

    Do you mind if I post that in the code bank?
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  10. #10
    Join Date
    Jun 2007
    Location
    Maitland NSW,Australia
    Posts
    388
    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.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •