Re: Counting Sequences Clarified

2001-10-02 Thread Paul DuBois
At 9:04 PM +1000 10/2/01, Bruce Collins wrote: >Hello, >Thank's for your interest Paul. I did a poor job >of explaining my problem. Here is another go: >For an athlete's first entry in the database I need a column >value of 1. The second performance entry of the same athlete >would have a value of

RE: Counting Sequences Clarified

2001-10-02 Thread Haapanen, Tom
ight now I don't understand the problem well enough to convince me that such maintenance would be worthwhile ... Tom Haapanen [EMAIL PROTECTED] -Original Message- From: Bruce Collins [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 02 October, 2001 07:04 To: [EMAIL PROTECTED] Subject: Cou

Counting Sequences Clarified

2001-10-02 Thread Bruce Collins
Hello, Thank's for your interest Paul. I did a poor job of explaining my problem. Here is another go: For an athlete's first entry in the database I need a column value of 1. The second performance entry of the same athlete would have a value of 2. And so on. I need to apply this retrospectively t