Query Cretira

[amfroehlich]

I have a query pulling one speific record. I want it to pull the last one saved to the database. Can i do this?

 

[Cbrine]

My suggestion would be to add a general timestamp to the table, that is updated to Now() everytime a change is made. You can then setup a query to with this datestamp sorted decending, and setup the query properties to return the TOP=1 records. This should return your most recent save.


PS- If 2 records were changed in the same second you might get the wrong one. If it's a single user entry database, this shouldn't be a problem. Multiuser could have this happen.

HTH
Cal

 

[Andrew Fergus]

Following on from Cal's suggestion, if you already have a variable that increases in value when a new record is added to the table (e.g. an autonumber or a numeric identifer), then you could select the newest item with a query (view totals) with the total part set to "Max" for that autonumber variable. Such a query would return one record being the last record in the table.

HTH, Andrew.

 

[Cbrine]

andrew,
I was thinking along the same lines at first. The only problem is that the OP didn't specify if the last saved record could be a modified record, as opposed to a new record. If modified with an autocount, the autocount would remain the same, if modified with a date/time stamp, the value would need to be updated at the modified time. Hense my using a date/time stamp.

Cal

 

[Andrew Fergus]

Hi Cal, a good point (that I hadn't thought of) - I had interpreted "last record saved" as being the last record created.

My misatke (spelling intended)