Return the last record altered

Wrox Programmer Forums

		Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB How-To
Return the last record altered

VB How-To Ask your "How do I do this with VB?" questions in this forum.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB How-To section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

February 13th, 2004, 12:53 PM

MikeJames42 MikeJames42 is offline

MikeJames42 is offline

Registered User

Join Date: Feb 2004

Posts: 9

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Return the last record altered

I am returning all the records from a query I have written but was wondering whether anyone knows how to just return the last record that has been added / or updated?

Thanks in advance

Old

February 13th, 2004, 12:57 PM

jrwlkn

jrwlkn is offline

Authorized User

Join Date: Dec 2003

Posts: 81

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Add a field to the table that auto time stamps the record. You can then use the max function applied to the timestamp

John

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Return one record per value	fizzerchris	SQL Server 2005	4	August 17th, 2007 09:31 PM
Return to Inserted Record - FormView	rit01	ASP.NET 2.0 Basics	15	January 27th, 2007 12:04 PM
return record count by quarter	jtyson	SQL Server 2000	1	June 29th, 2004 11:24 PM
Return a Record set into a table?	morpheus	Classic ASP Basics	2	November 18th, 2003 11:38 AM
Forms -- how to return to the same record and fiel	tcarnahan	Access	1	June 10th, 2003 11:24 AM