[AccessD] Seconds Missing

Hi Martin

How have you Dim'ed the global variable and how do you store the value
of it in the table?

/gustav


> Using an append query on an ODBC/Linked table.

> I need to retrieve the record when the user exits using a composite UserID
> and LoginInTime key and insert a logoff time however, the value I have
> stored in a global variable has seconds and the value stored in the table
> has been rounded to full minutes so I'm never going to retrieve the correct
> record unless the login was actually on the full minute.