Search results for query: *

rclarke250thank you so much. It was a combination of Fn + F11 because in order to get MacroRecorder I supposed to press Alt + F11 and probably accidentally took another accord

Right after I had attempted to create macro In Excel XP, when I tried to type "o " I get "6" instead and when I tried to type “I”, I get “5” instead (in WoRD and even Url).Os-Vista What I did wrong? How can I fix it? Would really appreciate for your help as I am unable to do anything!

Dear Experts, Not sure if it is a right forum… Please, readdressif otherwise. I have an interview in a week. In addition to my own expertise and experience they are looking for some familiarity with Business Objects. As far as I understand they just need somebody to work as Front End with BO...

I know how to do it in SAS but have no idea how to implement this conditional calculation in SQL Server 2005 The thing is that I would like to calculate HospDischDate=AdmitDt + LOSP in the body of Select Query: select field1 ,field2 ,?????? into desiredTable FROM myTable LOS is a length of...

Hello Experts! I have just faced problem of concantenating four tables with the same structure. Table1 Table2 Table3 Table4 I need the table named combined. How can I do it in SQL Server 2005? Thank you! Katrin

Hi experts, I need to append FOUR tables into one in Access 2007. Is there any way to do in by single query? Could you please help me with it? Any help will be greatly appreciated! Katrin

r937, Thank you for the response. I tried to run the query. However, after I had executed, system generated the following error message pointing to the ageCat line at the bottom(Group clause) Msg 207, Level 16, State 1, Line 21 Invalid column name 'AgeCat'. What could be wrong ?

Hi Experts, 1. I need first to categorize patients by Age: If memberAge in (21,22,23,24 ) then AgeCat=’Age 21-24’ If memberAge in (25,26,27,28,29) then AgeCat=’Age 25-29’ and so on 2. And group them by Age Category and Gender in order to get a count. How can I implement these steps in a...

Hi Experts, I need to to calc the percentage of members who had different medicl conditions by ICD-9 codes. Not just by primary diagnosis but by five diagnosis as there are 5 diag for each patient in DW. For ex I need ICD-9 214-215.99 for diag1,diag2, diag3, diag4, diag5 I believe it should...

Hi Experts, I really need your help.Proc contents gave me the following: Variable Type Len Format Informat Label AdmitDate Num 8 DATETIME22.3 DATETIME22.3 AdmitDate HospDischDate Num 8 HospDischDate looks like : 1594252800 AdmitDate looks like ...

Thank you. The thing is that I will have a training at work place. Meanwhile they sent to participants a "little homework" with instructions how to access data from Excel and with a layout. In the layout it was organized as I mentioned in the initial post where Asthma (1) & Asthma(2) are...

I accessed folders exactly in this way (path). The problem is that I am able to manibulate tables but cannot "drag" folders

They reside at SQL SERVER 2005 Analysis Services cube

Skip, this is MS EXCEL 2007

I have a list of folders and tables/fields under the folders. The problem is that I need folders in my list as the Row labels in the report while other stuff should appear on the right For example I have Folder named Asthma (1) under which I have Asthmatics(1)and Folder named...

Hi experts, For more than 10 monthes I was able to work from home throght citrix and perfectly used all employer company software and toOls. Recently something happened that I stopped get software any more. Although I am still able to log on to corporate system PC through citrix but I am...

Hi Glenn, Thank you for the response. Actually, I would agree with what you said. However I still have the same problem making a chart. Main pie looks OK while pie of pie shows just 22,3% and does not show 14.8 at all... What I am doing incorrect? That is how I organized data for the chart...

Hi Experts, I have a population of patients=3981 with certain diagnosis . -1478 of them met a certain medical procedure 1478/3981=37.1% -while the rest of them did not 2503/3981=62.9% -Besides the 1st category should be split up into categories: Teaching hospital and...

Skip, Actually the previous one has worked when I started from scratch! Thank you so much!

No, I do not although I was able to change data i "Select Data Source" box.