Daily posting of amount to a table

[wesley.allen]

Hello.

This may be difficult or impossible, but I would like to add a daily
record to a table in my database that would contain a balance in one
of my accounts. The balance is calculated using a sum table. I could
do this with an append query, but i wanted to know if it could be
setup to be done automatically each day, and if it could be done
whether or not I opened the database.

Thanks in advance.

 

[pietlinden]

Hello.

This may be difficult or impossible, but I would like to add a daily
record to a table in my database that would contain a balance in one
of my accounts. The balance is calculated using a sum table. I could
do this with an append query, but i wanted to know if it could be
setup to be done automatically each day, and if it could be done
whether or not I opened the database.

Thanks in advance.

Sort of. I guess you could get the code for the Scheduler at
www.mvps.org/access (I think it's in the modules section). then run a
routine that would
1. search for the record for that day.
2. if it does not exist, create a record with the balance.