I'm writing code that will populate a table with projected dollar amounts by month for a period of time input by the user when the procedure runs.
What I need to have happen is my code will generate a record where one field is the current month and year, then the next record it generates will need to be for the following month with a new projected dollar amount, and will continue until a specific number of iterations have been completed. When this code is first started, an InputBox pops up to ask the user how many months he/she would like to generate data for. The number entered is how many times a new record will be created, and the date field needs to increment one month at a time for each new record. Hope this explains it a bit better. ;-) Thanks, Bill R. --- In [email protected], "Eric Douglas" <[EMAIL PROTECTED]> wrote: > Bill, > > Is this in a table, or on a form? When you say, "one month at a time > for X months", do you mean that you want to add records to a table with > each value, or do you want a single control on a form to show an end > result of the final date? > > Or do you want it to increment by exactly one month until the user > performs some action, then increment another month, etc? > > With a little more info, I (or others) may be able to help. > > Eric > > > > -----Original Message----- > > From: [email protected] > > [mailto:[EMAIL PROTECTED] On Behalf Of bronicabill > > Sent: Wednesday, June 22, 2005 1:12 PM > > To: [email protected] > > Subject: [AccessDevelopers] How to increment a date value > > > > I am writing some code that needs to increment a date field > > by one month at a time for X number of months. As simple as > > it sounds, I have not yet found a way to do this! > > > > If anyone can tell me an easy way to do this, I would greatly > > appreciate it! > > > > Thanks in advance, > > > > Bill Rainey > > [EMAIL PROTECTED] Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
