Recent content by lareya

Thank you! This was exactly what I needed. I even can use it for my other staff files! I understand the inbuilt functions much better than the macro. I will try to figure out the macro. Thank you! Lareya ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++...

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

Okay, I was able to change the format to this: 03/01/1999 gave this: 01/01/1800 01-March-1991 13:23 gave this: 01-Jan-1800 7:30 I have noticed that my time fields that are zero'd out are actually datetime(1800,01,01,00,00,00) to get the no time & date Lareya...

hmm, when I put my cursor over the field it reads the field and has (date time) come up. However, when I use your field as you suggested the span midnight doesn't work. It acts like it really is just a time field? I rechecked my fields again. I went back into the format field and changed...

Just wanted to add that I changed the first line to check for time that spanned the midnight hour. numbervar timex :=IF {POST_CASE.LEAVE_PROC_ROOM_TIME} < {POST_CASE.ENTER_PROC_ROOM_TIME} THEN ((TIME ({POST_CASE.LEAVE_PROC_ROOM_TIME}) + 86400) - (TIME ({POST_CASE.ENTER_PROC_ROOM_TIME}))) /60...

You both are BEAUTIFUL people! thank you thank you! They both work, and plus I can learn from both examples! Lareya! ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Crystal XI; SQL database; MS Windows 2K; ORSOS/One Call Hospital Scheduling System v10.1.2...

I guess I am looking for is a formula that goes like this (quasi code) If the case is more than 30 minutes then 1 and if the case goes longer, break it up into 15 minute increments rounding up past 10 minutes. and it would show this level 30 1 15 4 or 30 -1 15 -4 or anything that...

Okay, the {POST_CASE.ENTER_PROC_ROOM_TIME} & {POST_CASE.LEAVE_PROC_ROOM_TIME} they are both date time fields that are formated to this 13:23 fields show this on a report 11:15 Room Time in (the words are my titles) 11:59 Room Time out thanks...

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

okay, I need the formula to check the different role codes. for the example I have been using for Provider I need to check for Role code 1 or 64. If they are not present, then I need to give the error msg "please check a Provider". I have 4 Roles to check for: Provider [1,64] Anesthesiologist...

Okay, I understand a bit more. The problem is that when I usually check for a code file I check if it is a empty/null field or if there is something in it. it would look like this: if {POST_RESOURCE.ROLE_CODE}= 1 then "I am not a empty field " Thus I don't generate a error msg. if...

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 thought that each of the different if-then-else statements that are separated by the ; means that they start over. Is that right? All the formulas are not interdependent. They are checking the same fields, but the formulas do not depend on each other. I thought it is checking first...

Okay, I thought that each of the different if-then-else statements that are separated by the ; means that they start over. Is that right? All the formulas are not interdependent. They are checking the same fields, but the formulas do not depend on each other. I thought it is checking first...