Search results for query: *

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

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

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

Hi, I have field called {RES6} which has a test name and value in it. the format of the field is CA125~56 The number is what I need extracting from the string...so basically the number after the "~". TheCA125~ is always constant I'm not so hot on these sort of things... Any help greatly...

Hi, The following formula gives me an error: numbervar mindiff; if isnull({PATDRUG.PRESC_TIME})or trim({PATDRUG.PRESC_TIME}) in [":",""] or isnull({PATDRUG.START_TIME})or trim({PATDRUG.START_TIME}) in [":",""] then mindiff := 0 else mindiff := datediff("n",datetime(currentdate...

Hi, I have a sql server db which has a field in a table called DRUGDETS. In this field is the following: Drugname Drugstrength Unit of measure, Route, Vehicle Example CISPLATIN 50 mg, IV Infusion, Saline 0.9% I want to be able to report on the Drugname and route eg CISPLATIN IV INFUSION...

Hi, I have an sql server db and want to calculate the difference between two time and dates, in hours. Field 1: {PHARMCHECKDATE} Datetime field (with no time entered) Field 2: {PHARMCHECKTIME} String field Field 3: {PRESC_DATE} Datetime field (with no time entered) Field 4: {PRESC_TIME)...

Hi, I have a db which records chemotherapy appointment data. I want to count the number of days a patient attends for treatment on a monthly basis. The database contains several rows for each days treatment and they can vary. Each row will contain the patients number, the appointment date, drug...

Hi, I have a database which has chemotherapy episode data in it. I want to be able to count the number of treatment episodes on a monthly basis, split by the ward or clinic area. Each patient will attend on a number of occassions over several months or years. Each time they attend I have...

Hi, I'm trying to order my x axis of my bar chart by year then month. The chart shows 12 months worth of data but it depends which months appear as to when its ran. eg could be May 07 to May 08. I want the chart to graph left to right starting with the oldest month first eg May 07, June 07...

Hi, I have a database which has patient episode information. Each patient will recieve a Cycle of treatment. Within the cycle can be any number of treatment days. For example Cycle 1 may have treatment days 1 and 8. And when they go onto Cycle 2 they may have treatment days 1, 8 and 15...