From: craig.futterman@nospam.comcast.net   
      
   Jean,   
   I did that and it works. It is just very slow when going through thousands   
   of records having to do thousands of queries.   
   Craig   
      
   "Jean Friedberg"  wrote in message   
   news:45e3072d$1@pnews.thedbcommunity.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)