Querying for last updated record

  • Thread starter Thread starter Lorra Rogers
  • Start date Start date
L

Lorra Rogers

I have a table that I am querying from that I need to be able to select the
record that was last updated. However, there is no 'last modified' field or
anything like that. Does Access keep this kind of information? Can it be
queried? I am using Microsoft Access 2000.

Thanks.

Lorra
 
No and no.

Access does not track this information for you.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top