Search results

  1. A

    Subtracting 2 dates and 2 times from seperate boxes

    Jus thought I'd offer this code to the forum as spent a long time finding a suitable solution.. SELECT DischargeTime.ID, [Arrival Times].ID, [Arrival Times].[A&EArrivalDate], [Arrival Times].[A&EArrivalTime], DischargeTime.[Date of outcome], DischargeTime.[Time of outcome]...
  2. A

    Another Median Query

    Hi, I am trying to run queries to determine the median values for different age groups of peoples each with different illnesses. At the moment the database asigns an age group for each person whos age falls into the module determined age brackets, under 16, 16 - 40, 41-50 etc. For each age...
  3. A

    COUNT Query problem Please help! XD

    Hey, Im implementing changes to a medical database and have come accross a query problem. I have one main table named Patient Info and from that I am wanting to report on anti biotic treatments with the 3 fields AntiBioticRegime (can be one of 5 drop down choices), AntibioticStartDate and...
Back
Top Bottom