From: craig.futterman@nospam.comcast.net   
      
   I am having trouble implementing some advice given me last week.   
   First the setup:   
   A normalized database where patients are admitted to the PICU.   
   Each admission has a set of unique identifiers for THAT admission and those   
   are used as the key fields (3 of them)   
   Each patient has a medical record number which I don't use as a key field   
   (too unreliable on admission).   
   The "Bioinfo" table has some demographic info: birthday, name, medical   
   record number, etc..   
   The "Medinfo" table has date/time of admission and date/time of discharge   
   (amongst other data)   
   I am looking for patients who bounceback to the PICU in less than 24 hours   
   after discharge   
   The data is there, I should be able to retrieve it.   
      
   First I query the two tables mentioned above and I get a list of all   
   patients admitted within a specified timeframe (the user chooses this prior   
   to launching the query).   
   The resulting table contains the unique identifiers, medicalrecord number,   
   date/time of admission and date/time of discharge (etc..)   
   Because this table is the result of a query, it has no key fields or   
   indexes.   
      
   Now, finally, my problem.   
   I was advised to use setrange on the medical record number so all the   
   admissions from each patient can be examined and I can find out if any   
   patients "bounce back" within a specified period of time (also pre-set by   
   the user).   
      
   How can I use setrange on a table which as no index set?   
      
   My assumption is that this is probably simple, I just can't figure it out.   
   Thanks for your help yet again,   
      
   Craig Futterman   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)