If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Progressive number
I've a query that make a progressive number NUM:
Num: (Select Count (*) FROM [CLIENTI] as AAA WHERE [AAA].[IDCLIENTE][CLIENTI].[IDCLIENTE])+1 NUM | IDCLIENTE 1 | 1 2 | 3 3 | 6 is it possible to have with same query an additional field with different progressive number in this example? NUM | IDCLIENTE | WAIT WEEK 1 | 1 | 1 2 | 3 | 1 3 | 6 | 2 4 | 7 | 2 5 | 9 | 3 6 | 12 | 3 Thanks in advance. St.1 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Number of Mondays in month | Michael Noblet | Setting Up & Running Reports | 3 | July 28th, 2004 10:41 PM |
Restart Autonumber | Traci | New Users | 22 | July 21st, 2004 01:10 AM |
Job Number Match function??????? | Russ | Worksheet Functions | 3 | April 19th, 2004 06:51 PM |
Excel- Inserting a varying number of rows | Ken Wright | Worksheet Functions | 1 | March 20th, 2004 10:20 PM |
18 digit number | kit | Worksheet Functions | 2 | December 9th, 2003 11:58 PM |