Select a last row in a table

[shek124]

I want to update a last row in the table when user logout of the screen . any body help me . very urgent


When the user log in , i have insert the values in login_tbl..
The field of the Login Table are Login_pk, user_pk_fk , intime , outtime ....


now i want to update the outtime correctly which the user enters.

plz help me

[kenobewan]

What is your platform, what have you tried so far?

[shek124]

im using Ms access .. when the user log in , i have the details of the user, login time in the login table successfully..m y problem is how can i update the logout time in the table when the user logout. i want a sq
l query for the problem.

[YGayatri]

im using Ms access .. when the user log in , i have the details of the user, login time in the login table successfully..m y problem is how can i update the logout time in the table when the user logout. i want a sq
l query for the problem.

Hi,
On click of "Logout" button, capture the time and insert it as "outtime" to the table before quitting the application.

[shek124]

Hai i have using the Hyperlink in my page

[YGayatri]

Hai i have using the Hyperlink in my page

Hi,
Try capturing the time on click of the hyperlink.
Also a hidden control, say a text box, can be used to store this time and value in this can be used to update the table.