08-08-15, 01:41 #1Registered User
- Join Date
- Aug 2015
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)
The form I will get query from
And how the results should look.
I am an intermediate at so please be gentle.
(***images were created in Excel for example purposes only)
08-10-15, 05:17 #2Jaded Developer
Provided Answers: 59
- Join Date
- Nov 2004
- out on a limb
by query alone tricky, very tricky, certainly outside my knowledge or time available
..you 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
...here's a an example of what can be doneholidaysample.pdf HolidayChart.zipI'd rather be riding on the Tiger 800 or the Norton