Query to display all the dates for the next week or month 2

[eatwork]

Hi, I need a query that will display the dates for the next week or month depending on the number of days I have selected. Does anyone have any idea how I can do this without storing the dates in a table? Thanks

 

[TheAceMan1]

How are ya eatwork . . . . .

Give an example . . .

See Ya! . . . . . .

 

[eatwork]

Hi TheAceMan1, you answer all the questions here? haha..
Well the situation is like this. The report is supposed to show the daily tasks for the next 2 weeks. Each task can span anywhere from 1-many days. I need a query to display each date for the next two weeks, for the parent report, so that I can find which tasks are starting or take place over each day. Any suggestions? thank you.

 

[eatwork]

Hi I guess I should add an example.
I have 3 tasks that starts on monday. the first task will last till weds, the second task will last till the end of monday, and the third task last until next week. There are 2 tasks that starts on Tuesday. The first of these tasks last a week and the next last 2 days. Etc...

If the report is printed/previewed on monday, the report needs to show all the tasks that are in progress for the next 2 weeks.

My query currently shows all tasks for the particular date because we have a taskStartDate and estimatedTaskEndDate. The main report uses a query to find all of the task dates that are between now and now + 14 days. The sub report currently joins the start date with the main report dates. This allows me to display all the tasks that start on that date, but it doesn't display the tasks that are still currently in process. Hope that makes sense. Any help/information will be greatly appreciated. Thank you

 

[PHV]

Something like this ?
WHERE [main report dates] Between taskStartDate And estimatedTaskEndDate

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[eatwork]

Hi PHV, Thank you for your reply. THis may sound stupid but what is the syntax tot access the main form variable date? If memory serves me right, accessing a form variable is Forms!formName.Form.control. Is it similar? thanks