Adding months to dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Our customers get our products once or twice a month for three years. If Jane Doe orders, in our database we have the dates she gets the products shipped (e.g., 4/1/04, 5/1/04, 6/1/04...or 4/1/04, 4/15/04, 5/1/04, 5/15/04....). I enter all these manually which is a total pain and ripe for error. Is there an automated way that I can have the dates entered automatically after I enter just the starting date? Can I just enter 4/1/04 and then all the data after that are automatically entered (the 5/1/04, 6/1/04, etc)? Thanks
 
Our customers get our products once or twice a month for three years. If Jane Doe orders, in our database we have the dates she gets the products shipped (e.g., 4/1/04, 5/1/04, 6/1/04...or 4/1/04, 4/15/04, 5/1/04, 5/15/04....). I enter all these manually which is a total pain and ripe for error. Is there an automated way that I can have the dates entered automatically after I enter just the starting date? Can I just enter 4/1/04 and then all the data after that are automatically entered (the 5/1/04, 6/1/04, etc)? Thanks
Click to expand...

You can run an Append query to do this. It's handy to have a small
auxiliary table for this purpose, say containing the first of every
month and the fifteenth of every month from now through 2050 or so.

If you use (as you should!!) a Form to enter this data, you can have
code in the AfterUpdate event of the first ship date (or some other
suitable event, such as a button click) to run the query, using a
criterion of

BETWEEN Forms!yourform!txtStartDate AND DateAdd("yyyy", 3,
Forms!yourform!txtStartDate)

to select the desired dates. The Query could pick up the other needed
fields (such as the customerID) from the form as well.
 
Back
Top