Error - View Single Post - Create Autonumber in QUERY not TABLE in Microsoft Access

**Anilrgowda** · 22-Oct-2007, 12:44 AM

SELECT A.[Ticket Number], A.CUS_NAM, (Select Count(*) From NAmeOFTable As B Where
B.[Ticket Number]<= A.[Ticket Number]) As NEWNO
FROM NameOFTable A

22-Oct-2007, 12:44 AM	#2 (permalink)
Anilrgowda Administrator Posts: 18,715 Join Date: Jan 2006 Rep Power: 10 IM:	Re: Create Autonumber in QUERY not TABLE in Microsoft Access SELECT A.[Ticket Number], A.CUS_NAM, (Select Count(*) From NAmeOFTable As B Where B.[Ticket Number]<= A.[Ticket Number]) As NEWNO FROM NameOFTable A ------------------