Recent content by gromboy

Hi, I'm working on a report from a sql server db which has chemotherapy data in it. I'm looking at Breast Cancer treatments. The patient will have elements of treatment against a diagnosis. For example Patient 1 will have a diagnosis of "Carcinoma of Breast Metastatic , HER2 positive 1st...

Sorry guys....... Won't happen again Steve

I see...This is the query I use at the moment... Could I add the min and max into this query and run it as a command ? SELECT "PATREGIM"."DISTRICTNO", "PATREGIM"."REGIME", "PATREGIM"."CYCLE", "PATREGIM"."CYCLEDATE", "PATREGIM"."ID", "PATREGIM"."STATUS", "PATREGIM"."MAXDAYS"...

My db is MS SQL 2005

OK...I thought it might be something to do with the min and max... However a view or command ?.... I'm not sure how to do that....sorry.... Are you able to help ? Steve

Ian, Following on from this...I have created a formula which groups together the output of the above formula. It looks like this IF {@weeks between last cycle and date of deat} IN (0 to 4) then "Up to 1 Month" ELSE IF {@weeks between last cycle and date of deat} IN (5 to 8) then "1-2 Months"...

Ian....thanks a bunch..works a treat

Hi Ian, I can't seem to get the formula to work... The fields are called {PATREGIM.CYCLEDATE} - Date/time field {PATREGIM.DISTRICTNO} - the patients number varchar field I have grouped the {PATREGIM.DISTRICTNO} field first and from this formula datediff("d"...

Hi, I have a db where a hopsital patient has appointment dates of treatment. It is a date/time field. I need to pull the first date for the patient from a list of appointment dates and calculate the difference between this and the last appointment date... Does anyone know how this could be done...

Hey....nice one...that worked a treat ! Thanks a bunch Steve

Hi, Thanks for your reply... I added my formula field into the replace formula as Replace({my_forumula},'-','') But it didnt do anything... The abs(my_formula) gave an error "A number or currency ammount is requireed here" Any ideas ? Steve

Hi, I have the following formula: numbervar mindiff; if isnull({PATDRUG.APPT_START})or trim({PATDRUG.APPT_START}) in [":",""] or isnull({PATDRUG.PRESC_TIME})or trim({PATDRUG.PRESC_TIME}) in [":",""] or isnull({PATDRUG.START_TIME})or trim({PATDRUG.START_TIME}) in [":",""] or...

Hi LB, I've finally got back to this issue ! I don't have a {table.alldates} field, only a TEST_DATE field for the toxicity test date, and an APPT_DATE for the appointment date. Is there another way ? Steve

Thanks for your quick reply...I'll see if I can do what you've suggested.. many thanks Steve

Hi, I have a chemotherapy database which has treatment cycle information. For example the patient may come today on Day 1, in a week for Day 8 etc.. During this time nurses may record whats called toxicity scoring, eg for vomiting 1-4 based on severity etc.. or hair loss, diarhoea etc I can do...