Recurring tasks

[fmaca]

Good afternoon all.

I need to set up something for recurring tasks.

I have a start date in normal date format and a task interval in number of weeks.

I'm hoping that there is an expression that I can use in a query that will flag the tasks that need to be done this week based on the above information.

I'm concerned that converting everything to weeks will cause a problem over year end.

I could change the task interval to days if needed.

VB is beyond me at this point.

Dropout

 

[dhookom]

Are there any tables or fields you would like to share or are you asking for ideas on how to set up your tables?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[PHV]

Have a look at the DateAdd and the Date functions.

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

 

[fmaca]

Hi All.

I used the DateAdd and rearranged my data and got it to work.

Thanks.

 

[fmaca]

Hi again.

My previous solution isn't working out so well.

I have three fields, LastPickupDate, PickupInterval and NeedPickup.

The NeedPickup is currently calculated by adding PickupInterval to LastPickupDate. However this involves constantly changing the LastPickupDate.

I would prefer to use a field called InitialPickupDate and be able to calculate the NeedPickup based on the PickupInterval andbe able to dispense with the LastPickupDate.

I'm converting everything into weeks.

I have not figured out how to use VB so am wondering if this can be done in a query.

Thanks in advance.

 

[dhookom]

You don't need to store all three values. Any two should allow you to easily calculate the 3rd. I am still not sure on your data, process, desired query output... Do you store a pickup history in any table?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[fmaca]

I have a list of 100 locations that need I need to pickup from on a regular basis, some every week, some every 2 weeks, some every 4 etc.

I would like to run a query every week that lists the pickups that need to be done that week based on the InitialPickupDate and the PickupInterval.

I would like use this query to create tbl_Pickups.

That table will have all pickups and the dates they were done giving me historical data.

 

[dhookom]

There is a sample "recurring" database at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

that might help you create your schedule.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[fmaca]

Thanks for the link.

That is based on VB (I think), not queries, and VB is beyond my ability.

 

[dhookom]

The sample uses VBA to create a schedule. This was the easiest, most flexible way of accomplishing the scheduling.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]