How can we implement a Temporal database in MS-ACCESS.

i have a table some of its records will be valid till a particular
date and then they they r no longer valid but due to this nature i
cannot delete them since i need them for DATA ANALYSIS.

Waiting for assistance,
Jogen Shah

I hope you can give us your question more clearly.

I have not heard of a Temopral database.
Do you mean temporary? If you need a temporary table, I believe you
would easiest name it tmpTableName when creating, and delete it via code
or manually when not needed.

I think maybe you want to keep a table - but have certain records not
used. If so, a boolean field (Yes/No) in the table will let you use a
query's Where clause to exclude those records from use and analysis
later. Or, if the drop-dead date is recorded in the table, logic in the
query can exclude records where current date [use the function Now() ]
is greater than the drop-dead date. Either method will let you keep the
record and ignore it when you want.

Bruce Pick

Jogen Shah wrote:

Have a field which gives a duration - in whatever units you need. Then,
when you query, use less than duration number for current records in
addition to a date parameter.

Leah

"Jogen Shah" <jogen (AT) temple (DOT) edu> wrote