Recent content by aphex

Ignore me, do what pbaldy says! :)

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]...

omg this is infuriating! afore mentioned queryb was working absolutely fine up untill a few minutes ago when it decided not to recognise one of the medians im wanting to work out, even tho it was there 2 minutes ago...

here is an example of how im trying to approach the problem... SELECT AgeGroups([Patient Info]![Age]) AS [Age Group], Count([Patient Info].[Patient Info ID]) AS [CountOfPatient Info ID], Avg([Patient Info].Age) AS AvgOfAge, Min([Patient Info].Age) AS MinOfAge, Max([Patient Info].Age) AS...

Ok think I have now got to a stage where my age distribution functions are almost working.. I have one query (queryA) determining the min, max, average and occurances of each age group. Then I have another several queries giving me lists of ages in each age group, i.e Where PatieintInfo.Age >41...

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...

Decided to use the TEMP_TABLE method as the anti bitoic regime only accects about 10% of patients per year on the database so wont get too high in the next few years.. Also couldn't get the nesting to work, for some reason no temp relationship was being created when I was making up the new...

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...