Need Help

[rohanmalhotra83]

Hi

I have a table in which one record gets updated multiple times. I want to run a query that gives me the latest update.

Thanks in advance

 

[vbaInet]

Create a Date/Time field in the table and for every update amend the field to Now().

Create a query and sort by the Date/Time field.

 

[rohanmalhotra83]

Thanks... but i want only the updated records.

With this query i am still getting all records.

 

[JamesMcS]

Just filter the results by now(), simples! Or more accurately a range

 

[vbaInet]

Yes, for recent records you have to have a time limit, so set the Time criteria under the Date field. Search the forum on how to do this.