Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: katrina11
  • Order by date
  1. katrina11

    Accidentally changed Register settings (?)

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

    Accidentally changed Register settings (?)

    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!
  3. katrina11

    Business Objects for the beginner

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

    Conditional Calculation in SELECT quert (SQL SERVER 2005)

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

    How to append four tables?

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

    How to append 4 tables into one by a single query in Access 2007?

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

    categorize by Age and then to count by Agecat & Gender (single query)

    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 ?
  8. katrina11

    categorize by Age and then to count by Agecat & Gender (single query)

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

    How can I do it through an Array? Or other efficient and simple way?

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

    How to convert date in order to match another date?

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

    Failure to make Folders as Row Lables using a Pivot Table .

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

    Failure to make Folders as Row Lables using a Pivot Table .

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

    Failure to make Folders as Row Lables using a Pivot Table .

    They reside at SQL SERVER 2005 Analysis Services cube
  14. katrina11

    Failure to make Folders as Row Lables using a Pivot Table .

    Skip, this is MS EXCEL 2007
  15. katrina11

    Failure to make Folders as Row Lables using a Pivot Table .

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

    Log on but unable to see corporate software on my Windows Vista . SOS!

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

    "Pie of Pie" problem in Excel 2007

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

    "Pie of Pie" problem in Excel 2007

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

    Excel 2007:Unable to get years at horizontal Axe

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

    Excel 2007:Unable to get years at horizontal Axe

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

Part and Inventory Search

Back
Top