C Chrisopia Registered User. Local time Today, 11:11 Joined Jul 18, 2008 Messages 279 Oct 12, 2009 #1 Is this possible? if so how would I apply that into access? I only need this at table level, but if this isn't possible - i.e. through a query, what is the best way to do this and how??
Is this possible? if so how would I apply that into access? I only need this at table level, but if this isn't possible - i.e. through a query, what is the best way to do this and how??
John Big Booty AWF VIP Local time Tomorrow, 04:11 Joined Aug 29, 2005 Messages 8,262 Oct 12, 2009 #2 Check out the Dmax() function. Try Dmax(FieldName,TableName)+1