How do I number each record in a query (1, 2, 3...)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to number each record in a query using a sequencial number from 1-3
and the start over, example:

Sequence #
Record A 1
Record B 2
Record C 3
Record D 1
Record E 2
....
 
You need to identify an ordering field. The following is an example using
the Customers table in Northwind.mdb.

SELECT Customers.CustomerID,
(SELECT Count(*)
FROM Customers C
WHERE C.CustomerID <Customers.CustomerID) Mod 3+1 AS SeqNum
FROM Customers
ORDER BY Customers.CustomerID;
 
Back
Top