ms access data

  • Thread starter Thread starter supernerd101
  • Start date Start date
S

supernerd101

I am trying to setup a database (budget), I am wanting to set the
transactions to repeat say every 2 weeks or every month. Is there a way to
do this in access.
 
Thanks, I'm trying to get to something ms money did where you put the
transactions in and it automatically put the transactions for future
transaction in the register.
 
Thanks, I'm trying to get to something ms money did where you put the
transactions in and it automatically put the transactions for future
transaction in the register.
Click to expand...

How many? For the rest of the year? Until December 31, 9999AD (the limit for
Access dates)? Selectable?

You'll need to run an Append query to do this; it's handy to have an auxiliary
table named Iotas, with one long integer field Iota with values from 0 through
10000 (or some larger number than you'll ever want). You can use this in
conjunction with the DateAdd function and query criteria to specify what dates
and how many of them to add.
 
Back
Top