Displaying the 5 last records used

[noks]

Is there a way i can display the 5 last storenames i've saved?

Like the myrecent document in ms office
Pls kindly help

Regards
Noks

 

[ColinEssex]

Unless you date and timestamp them, I'm not sure you can.

Col

 

[noks]

yep i do have a timestamp...(date & time)

 

[ColinEssex]

So do a reverse sort and select the Top 5.

Col

 

[shadow9449]

So do a reverse sort and select the Top 5.

Col

The challenge is when you have your application running on several computers on a network. (This is regardless of whether you've split it or not.)

I've had to maintain a table that stores the ID, computer name and timestamp every time a user accesses a record, then query this table when the user wants to see the most recently accessed records only on HIS/HER computer.

SHADOW

 

[noks]

SELECT TOP 5 Sasol_Campaign_history.[Store Name] FROM Sasol_Campaign_history ORDER BY Sasol_Campaign_history.txtDate DESC , Sasol_Campaign_history.[Store Name];

Thanks guys