Re: Access - Autopopulate Date/Time?

by "Angie Michaels" <angiemichaels(at)blueyonder.co.uk>

Date:	Mon, 26 Mar 2001 16:11:22 +0100
To:	<hwg-languages(at)hwg.org>
References:	swbell
	todo: View Thread, Original

> I am using Access 2000. Is there a way to autogenerate a date/time stamp
> when a record is created or updated? I can't find anything in the books
> on this.

In access the field should have date() in it or you could use now()

> Also, if there is, what would be a SQL query to pull the 5 most recent
> added or updated records?

open the db in descending order and then read the db one file at a time
which will display the last five but in descending order.

Alternatively open DB and count how many entries, then move to first record
and count down to total number of entries less 5 then display last five.
(displays in order added)

Angie

HWG: hwg-languages mailing list archives, maintained by Webmasters @ IWA