Fly_Moe
05-11-2007, 03:18 PM
Here's my query:
SELECT units, nation, unique_brigades,
Switch ( [unique_brigades]='A', 2000, [unique_brigades]='B',3000, [unique_brigades]='C',4000) AS brigade_number,
unit_urn_desc AS urn_desc
FROM units
What I'd like to be able to do is increment the values (2000,3000,4000) by 1 for each new row. Does anyone know a way to do this?
Thanks in advance for your help.
SELECT units, nation, unique_brigades,
Switch ( [unique_brigades]='A', 2000, [unique_brigades]='B',3000, [unique_brigades]='C',4000) AS brigade_number,
unit_urn_desc AS urn_desc
FROM units
What I'd like to be able to do is increment the values (2000,3000,4000) by 1 for each new row. Does anyone know a way to do this?
Thanks in advance for your help.