Recent content by FB1

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