Search results for query: *

Hi Products: Office 365 Enterprise E1 ,NHSmail 2 , Windows 10 and Community cloud using Azure Investigating Office 365 for a NHS CCG. They are using NHSmail2 and will no doubt be using this until 2020. I am investigating benefits and deployment of O365 having own tenancy on a community cloud...

GM 9 office 2007 word Hi Clients double clicks on GM template, prints off document , doesn't save. But word is creating a obscure number file name with file type as dotx in My Documents Any ideas how to turn this off your help is most appreciated

Thank you all for your replys. Have now worked out how to obtain the correct data, I needed

MYSQL 5 Hi everyone Wonder if you could help me have a table with 5 field startdate, enddate, dose, equipment, patient Data is set out as such startdate - enddate - Dose -- Equipment - Patient 01/01/2010 01/02/2011 15 iv 101A 01/02/2011 01/03/2011 15...

Hi Everyone CR 11 MySQL Have a report where a person attends 2-3 appoinments every week, they must attend on the correct days of the week ie Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday. I have 3 fields with the relevant day in Shift1, shift2, and shift3. ( if they only...

Thank you for your reply, manage to work where I was going wrong ,(select distinct p_haematology1.h1dat from p_haematology1 join( select p_haematology1.fk_oid,max(h1DAT) as h1dat91 from p_haematology1 join p_anthropometry on p_anthropometry.didat=p_haematology1.h1dat...

Hi MYSQL 5.2 I have two queries that pull dates out from different table One date comes from ob_table the other from HB_table both dates look for an interval from now to -91 days both queries work well. I now need to join the queries together to get the HB date where there is an...

Thank you Rudy and Feherke manage to work out a way to do this with the following query 0+replace(replace(replace(replace(replace(pre.prunit, 'm',''), 'c',''), 'g',''), 'u',''), 'i','') as units, But thank you both for all your time

Mysql 5.2 Good Afternoon all have a field which is a string that I need to convert to a number. in crystal I would convert the field as such val({doses}). I can use the VAL() statement to strip out the non numberic characters. can this be done in mysql the characters I want to strip out are...

Hi Ibass Sorry for Cross posting, wasn't sure which area to put it into. Have you come across the above issue before, not sure what to do, have you any ideas Thank you ralph

Hi Everyone Crystal Reports 11 MYSQL 5.2 Created a sql query that joins two areas together. Have created set variables that work perfectly in MYSQL but when putting into crystal they are not liking them. Please you tell me what I am doing wrong. Thank you for all your time. The set@i create a...

Hi r937 just thought users with mysql experience had come across the issue before thank you for replying.

Good Afternoon Crystal 11 MYSQL 5.2 In mysql to declare a set I use @ at the beginning, problem I have there is Crystal doen't understand this, what do I use instead of @ my code as follows set @i = -1; set @StartDate = '2012-07-01'; set @EndDate = '2012-07-31'; ##Combined Data SELECT...

Hi Everyone Crystal Reports 11 MYSQL 5.2 Created a sql query that joins two areas together. Have created set variables that work perfectly in MYSQL but when putting into crystal they are not liking them. Please you tell me what I am doing wrong. Thank you for all your time. The set@i create a...

Hi Everyone Crystal Reports 11 MYSQL 5.2 Created a sql query that joins two areas together. Have created set variables that work perfectly in MYSQL but when putting into crystal they are not liking them. Please you tell me what I am doing wrong. Thank you for all your time. The set@i create a...

Good Day Crystall 11 I have multple data from different formulars that need to be shown on four line only. I have created the formulars for each entry if {Command.Mode} <> 'HD' or {Command.Mode} <> 'RIP' and {@PTHTest} = 1 Then 'PTH' else '' this gives me 30 fields, yes I could create a...

Crystal reports 11 Mysql 5.2 vital plus system within vital plus system using crystal reports viewer have patients record open and run a report against this patient for prescriptions The report looks for patient then links to their medication table and only shows the drugs they have been...

Good morning everyone your help would be most appreciated in the following problem I am having. HD_OBs (FK_oid is the main link this is the Patientid) select oid, fk_oid, DIDAT as HDDate, haloc as location, access_used from p_anthropometry order by didat desc; -- HD_Prescription...

Crystal Reports 11 MYSQL 5.2 Hi Everyone -- HD_OBs (FK_oid is the main link this is the Patientid) select oid, fk_oid, DIDAT as HDDate, haloc as location, access_used from p_anthropometry order by didat desc; -- HD_Prescription (FK_oid is the main link this is the Patientid) select...

Crystal 11 using sql commands Have a 3 page report 1st page always gets printed Page 2 only gets printed if Patient = HD Page 3 an extended page only gets printed if user requires it 1st page is simple #2nd page will depend on a formular, but what formular do I need to use for printing #3rd...