M mulisha07 New member Local time Today, 14:34 Joined Oct 14, 2004 Messages 8 Oct 17, 2004 #1 Hi...can i make a query that will show the most recent ID. Example..i have a NameID which is set to auto number..and i want the query to show the current record ID..issit possible?
Hi...can i make a query that will show the most recent ID. Example..i have a NameID which is set to auto number..and i want the query to show the current record ID..issit possible?
pbaldy Wino Moderator Staff member Local time Yesterday, 23:34 Joined Aug 30, 2003 Messages 36,274 Oct 17, 2004 #2 SELECT Max(NameID) AS MaxNameID FROM TableName
