Create Tasks from specific date (1 Viewer)

ZuluWarrior

New member
Local time
Today, 11:21
Joined
Sep 13, 2016
Messages
2
Hi All, I would like to be able in Access Web Apps create several tasks based on a date. Example would be I create a new record with RaceName =ABC and have various other fields one of which is RaceDate =1234. I now need access to create several tasks for RaceName = ABC using the RaceDate=1234 as a guide/starting point

So I need Access to create a task 30 days after RaceDate=1234 and then another different task 90 days after RaceDate =1234 etc etc

Hope this makes sense
 

sneuberg

AWF VIP
Local time
Today, 04:21
Joined
Oct 17, 2014
Messages
3,506
I don't know what you mean by RaceDate =1234 but if this is just a bad example of a date then you would use the dateadd function to calculate a date 30 or 90 days from a date.
 

ZuluWarrior

New member
Local time
Today, 11:21
Joined
Sep 13, 2016
Messages
2
Hi sneuberg - sorry bad example

I have one table that holds my race dates, names etc
I have another table called TASKS
What I need to do is create multiple tasks using the date in my Race table.

So using date in race table create a task in the tasks table 30 days after race date.

Then same again but 90 days after race date.

This might not be the way to do it so open to suggestions
 

sneuberg

AWF VIP
Local time
Today, 04:21
Joined
Oct 17, 2014
Messages
3,506
Please explain how you want this to happen, e.g., do you want to add these task records by clicking a button in a form that's showing the race? Do you have a relationship set up between the table of races and table of tasks?
 

Users who are viewing this thread

Top Bottom