Search results for query: *

Hi all, I have a staff file name which has the lastname,firstname in one column. I want to take all the names and regardless how long the names are in character, I want to have the lastname be four charachter, and the firstname in four charachters. thus: pierce,marta will be added to the H...

Can someone help me with a formula that will add some time up for me? {POST_CASE.ENTER_PROC_ROOM_TIME} enter Rm time {POST_CASE.LEAVE_PROC_ROOM_TIME} Lv Rm time I use these fields for times on the report. I need to have a formula that will see the first 30 min and then see the remaining time...

I have a validation report that checks for different Staff people in Surgery. The Report only looks at one Nursing Record at a time. They are linked by Case_No. I have 4 formulas that all follow the same pattern. I have created 4 alias to the same table - Post_Resource. The Post_Resource...

Hi all, I have some code that works. WhileReadingRecords; Local StringVar strValidate2; IF {POST_RESOURCE.ROLE_CODE} in [1,64] then // No Provider Code if strValidate2 = "" Then strValidate2 := 'Please Check the Provider Field' else strValidate2 := strValidate2 &...

Okay, I guess I don't quite understand null. Here is the problem. I have a forumula that checks if a bovie is being used or not. This formula works. if ( isnull({WP_CAUTERY_DTL.SERIAL_NO_CODE}) ) then "No Bovie" else 'bovie used' However if I try this forumula (not null) then it doesn't...

Okay I have a formula that should be working, but isn't. here is the formula: if {WP_INTRA_OP_02.TOURN_UP1_TIME} <> datetime(1800,01,01,00,00,00) OR {WP_INTRA_OP_02.TOURN_DOWN1_TIME} <> datetime(1800,01,01,00,00,00) and {WP_MISC.CODE_17} = 0 or isnull({WP_MISC.CODE_17}) and...

I have the following code that validates a users screen (surgery charting). How can I place these formulas so the info looks like this: Please return to the Procedure\Staff\Room Button & go to the Procedure Screen Tab and check the Wound Class Field Please return to the Procedure\Staff\Room...

I have a question regarding groups. Currently I have two groups group one is a use a formula for a group name: IF {POST_CASE.MAIN_PROCEDURE_ID} IN ["092200", "092205", "092300", "096853"] THEN "ASSORTED COLON CASES" ELSE IF {POST_CASE.MAIN_PROCEDURE_ID} = "085400" THEN "TOTAL KNEE...

Okay, Is it possible to check what DayofWeek it is in regards to where it lies in each month? Example 1st monday, 2nd monday, 3rd Thu, 5th Friday of the month? I have a formula I found that gives the Last Month of the Day. here: dateserial(year({Post Case.ENTER_PROC_ROOM_DATE}), month({Post...

Okay, I found this in the faq. I think this is close to what I need. However, I only want to see the 2nd & 4th Monday of every month. How do I select that from this formula? local dateTimeVar InputDate:={Post Case.ENTER_PROC_ROOM_DATE}; local numbervar A; local numbervar B; local datevar C...

I have a field named {Post Procedure.PROCEDURE_DESC} it is a string w/ legnth 75. I want to make a formula that will look at this string field, and check and see if the word (s) "colon, colectomy, bowel " are in this field. I would like any of these words to be able to print out on my crystal...

Hi, I have a report with this type of set up. These are all different types of procedures sorted by their table as to what they are. general surgery, ent surgery, gyn surgery, and ortho surgery....ect. I have about 10 different types of surgery. I call them by their procedure_ID...

Okay, I am using MS Excel 2002 w/Win2k. this is what the original LookS like: A B C D CT GEN OLD PROCEDURES NEW PROCEDURES 1 BB1EZ093300 BB1EZ ABDOMINAL PERINEAL 2 BB1HZ095700 BB1HZ ADRENALECTOMY 4 DB2EZ091420 DB2EZ ANAL FISTULECTOMY 5 DB2EZ096897 DB2EZ ANOPLASTY...

Okay, I am using MS Excel 2002 w/Win2k. I have a spreadsheet that looks like this COUNT OLD NEW OLD PROCEDURES DESCRIPTION 1 20110 BC5 ALVEOLECTOMY 2 20100 BC5 ALVEOLOPLASTY 3 020120 BC5 BIOPSY MANDIBLE 4 020420 BC5 DENTAL BRIDGE(S) INSTALLATION 5 020400 BC5 DENTAL CROWN...

Hi, I am using excel 2002. I have a simple, but large spreadsheet. Name Procedure Procedure ID Dr. X lap chole 123456 Dr. Y lap chole w/grams 123456 Dr. z open chole 112456 Now, all I want is to take the column of Procedure ID and format all the...

I have created a report that shows providers and procedures. I have grouped on the providers. I have Record sort order the procedures to descend. I have the procedures TopN by most freq. I have counted each procedure. It looks like this: Provider Procedure Dr x Proc...

Hi, Is there someplace/where I can find info on the topN and sorting? I can't seem to make heads and tails, and have tried hundreds of different ways for my formulas and info to be all wrong. I asked a question here re: my report, but I didn't understand the suggested solution. I really need to...

I would like to use the TopN/bottom N function as a parameter, eg. ?top N = // allows user to chose 1,2,etc., and then a ?bottom N also with same choices. the report should looks like this: Top ?N (eg 1) Proceduces/Providers Provider Procedures (this would give their top...