Time based entry

M

myxmaster

I was wondering. Is it possible to automate a table or field entry
based on time criteria.
I am creating a database where the user will have to designate a
transaction "cleared "for the balance to be reflected correctly.
Can I do this automatically to avoid human error. For example it takes
10 days from a transaction entry to clear, therfore after 10 days I
would like it to be reflected automatically if the user has not
manually made the adjustment.

TIA
 
E

EeOr

You could try this using an update query that runs when the database is
opened, something like:

UPDATE yourtable SET yourtable.Status = "Cleared"
WHERE (((yourtable.datefield)<Date()-10) AND
((yourtable.Status)="Waiting"));

This should run and update the status of any records that have a date over
10 days old and a status of waiting.

Jon
 
T

tina

if you're using queries and/or reports to do the math that returns a
"balance", just include only records where TransAction date is <Date()-10.

hth
 
M

myxmaster

EeOr said:
You could try this using an update query that runs when the database is
opened, something like:

UPDATE yourtable SET yourtable.Status = "Cleared"
WHERE (((yourtable.datefield)<Date()-10) AND
((yourtable.Status)="Waiting"));

This should run and update the status of any records that have a date over
10 days old and a status of waiting.

Jon
Click to expand...
 
Top