Hello Mr. Richard, I am from India, Nagpur, and I Am 53 but still very curious to learn Access in toto. I have already prepared a number of Projects in Access for Office to make my work easier with my meager knowledge, started watching your videos, and am very happy. Thanks so very much. My question is How can I increase the dates by specific intervals by putting just one date, I will put 01-01-2022, and the next result will be 8-1-2022, 15-01-2022, 22-01-2022, and so on for each month for the rest of the year. I hope you got my query. Regards Manish
Adam Schwanz
@Reply 4 years ago
For Next Loops Make a loop add 7 to the date repeatedly to create new records while the Year of the date is still the Year of the date you put in using the Year(field) function
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
