Frozen TimeStamps

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Greg Rodgers (anonymous_at_discussions.microsoft.com)
Date: 04/23/04 

Date: Fri, 23 Apr 2004 07:49:26 -0700

Hello,

I have a database in which users update information and
the info is timestamped.

When I query this data, I use a select query to pull the
last update (Timestamp) only. This seems to work, but
every now and then its seems that the query gets stuck on
the third to last timestamp and will not pull the last
update.

Does anyone have any Ideas as to why this may happen?

Greg Rodgers

Relevant Pages

  • Re: error pulling data from query using a command button on a form
    ... You can't refer to fields in queries that way. ... What is DET1PERSONNEL1 Query? ... > 'I am attempting to pull data from a column in a query. ... > Private Sub UpDateSingleRecord_Click ...
    (microsoft.public.access.forms)
  • Re: Access Table Sorting/Query Last Function
    ... The table is set up as a datasheet. ... of the Lastin your totals query. ... I've been designing a database that basically works off two tables. ... I've done this so that I can pull the last entered ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Access Table Sorting/Query Last Function
    ... I've put in a number of test entries to ensure it works, ... of the Lastin your totals query. ... I've been designing a database that basically works off two tables. ... I've done this so that I can pull the last entered ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Link Pulldown to Query
    ... I want to use a pull down menu to select data that will then be used to ... >> results of the query. ... >> reading the selection data from a Access table. ...
    (microsoft.public.access.gettingstarted)
  • RE: Need to be able segregate units run in excel sheet using time.
    ... It may be possible - using the timestamp as I ... you add the time stamp at the time the query was run. ... > I don't see a way around this, unless there is more to the database than I ... > the type of situation I describe above better than you can in Excel. ...
    (microsoft.public.excel.programming)