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.

On Oct 31, 8:49 pm, "wesley.al...@gmail.com" <wesley.al...@gmail.com>
wrote:
> 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.