Hey Charles, sounds like you are in need of a view.
what database are you using? ----- Original Message ----- From: "Charles Brown" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, December 02, 2003 5:16 PM Subject: Witango-Talk: Incremental Count of Subgroup Instances > This has got to be easier than I am making it. I have a table of client > id numbers and their visit dates. I need to sort by the client id and > date and assign the number of their visit - from 1 to n. - in a visit# > field on the corresponding row in the table. So, for example, visit #4 > for Fred was on 12/21/2003. Please speak real slow when responding to > this request for assistance. I am not real quick on the uptake today. > Oh yeah, the table has over 90,000 records in it, so I can't just give > up and do it by hand. > > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
