From: jfriedberg@mycomcast.com   
      
   Craig,   
      
   Give your answer table a name like "temp1".  Query temp1 for the specific   
   medical record number you want records for.   
      
   Jean   
      
   "Craig"  wrote in message   
   news:45e30596$1@pnews.thedbcommunity.com...   
   > 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)