Repeat data from a given date

[easygoingdave]

I am currently updating an old Db which rosters staff. One of the enhancements will allow the user to automatically allocate staff details to a Roster after a given date. i.e. Roster date 20th Feb 15, repeat for 3 days. 21st 22nd 23rd Feb 15. I have created a form with a medium date field and then a Combo box with drop down values of 1 thru 7 days. I want to link the combo box value to the Date box. Any help would be appreciated.

 

[CJ_London]

It is not clear from your post if you want to calculate the 'ast date' or all dates between first date and last date.

Also, not clear what you mean by

link the combo box value to the Date box

if you want to calculate the startdate plus number of days, this would be either

mydatecontrol+mycombocontrol

or

dateadd("d",mycombo,mydatecontrol)

replace names to the names of your two controls

 

[easygoingdave]

thanks for the reply, and apologies for the lack of information. The current Db is for a small security firm whose staff are employed at different sites for 1 or several days. The current form only allocates one day at a time. If a member of staff is allocated 5 days work at the same site, the user has to go in 5 times with the same staff details. I was hoping i could add a list or combo box with a drop down list of 1 thru 7 days. when the user selected the start date and number of days it automatically populated the staff details in the roster for each one of those days. I hope this clarifies my earlier post.

Regards
Dave

 

[CJ_London]

OK. well my original suggestion still stands, but

it automatically populated the staff details in the roster for each one of those days

to do this requires one of two things

If the roster already exists populated with all dates then you can do this with an update query

If it doesn't then you need to use VBA and loop and insert a record one at a time for each day

So, if you require additional advice, we will need to see your table design and relationships (a screenshot of the relationships form will do it)

and some example data (can be test data) of the table contents for probably employees and roster both before the action is taken and after

And since roster can mean different things to different people, an example of the report you require