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!

Register Log in
  • Congratulations Rhinorhino 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: lareya
  • Order by date
  1. lareya

    Excel macro question w/ strings

    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 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++...
  2. lareya

    Excel macro question w/ strings

    ...Resident GENERAL 1220 FARROKHI,FARZAD 92808 Anesthesia Resident PAIN MANAGEMENT 480 HAWORTH,JOHN 92059 Anesthesia Resident PLASTIC/RECONSTRUCT* Can s/o help me do this? I am hoping that a macro will do this. I will have several staff files that will need this same thing done. Thank you...
  3. lareya

    time formula help (addition)

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

    time formula help (addition)

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

    time formula help (addition)

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

    time formula help (addition)

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

    time formula help (addition)

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

    time formula help (addition)

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

    time formula help (addition)

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

    Can S/O check this formula, linking &amp; logic?

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

    find the negative array formula

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

    find the negative array formula

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

    find the negative array formula

    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 &...
  14. lareya

    null and not null formula

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

    null and not null formula

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

    null and not null formula

    Okay, I was trying to cut and paste the extraneous info in my formula, thus the mistake in the field name. Here is the full formula. It checks first if the bovie is used, then it checks if the coag & cut is being used, then all the code checks are for bovie pad placement. Thus...
  17. lareya

    null and not null formula

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

    If then else formula question

    Thank you so much! That works perfectly! Is there a faq that covers things like you mentioned above? I would love to know more tricks like that! >>First, you should set off "or" statements in parens so that it is clear what clauses belong to each other. You also should test for nulls before...
  19. lareya

    If then else formula question

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

    multiple formulas formating?

    You are so right! I re-checked my formulas, and I had a little boo-boo (typo) in it. Thank you so much! Lareya! I will continue to re-use this convention, and place multiple sections in the header to supress, and I think my validation section will work quite will. Thanks again...

Part and Inventory Search

Back
Top