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 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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.