Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2015

    Wink Unanswered: Schedule Query, Start Date End Date

    Thanks in advance for all the help.

    I am trying to create a query that will give all the dates from Start Date to End Date in Access 2013
    the start and end dates are in a table (tJobList)
    I would like a simple table style schedule generated.

    Here is the table (tJobList)
    Click image for larger version. 

Name:	projlist.JPG 
Views:	3 
Size:	24.3 KB 
ID:	16507

    The form I will get query from

    Click image for larger version. 

Name:	formsch.JPG 
Views:	2 
Size:	14.5 KB 
ID:	16506

    And how the results should look.

    Click image for larger version. 

Name:	qrysch.JPG 
Views:	2 
Size:	21.6 KB 
ID:	16508

    I am an intermediate at so please be gentle.

    (***images were created in Excel for example purposes only)

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    by query alone tricky, very tricky, certainly outside my knowledge or time available may be able to do this by joining your data to a dates table to extract every valid date in your date range, then using a pivot table on that joined wuery foprmat it as you require

    but if you are doing this in form or report you can probably do it by tinkering with some VBA and populating controls on the fly's a an example of what can be doneholidaysample.pdf
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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