Search results for query: *

I need to split the string below to only get the numbers after the "=" sign and before the word "unit" There is a possibility that this could be a 2 digit number. I will need to have each number available to assign to a text box. Sensitive 0601-2059 bg</=70 hypoglycemia*71-150 no...

Hello all! I am a complete noob, and I will try to explain what I am trying to accomplish. I have several modifiers for diets, and only some of them pertain to the main diet. I would like to make sure the box that is to be hidden is unchecked and then hidden, the code below works, but I was...

Good afternoon all! I am using Crystal Reports 2011 and I have a problem with a field. This field mostly contains text, but sometimes contains numbers. Sample of data is: kerlix kling 21 13 When I display the report, the numbers are not present, just a blank line shows. I have tried the...

Hello all! I am trying to report on orders using the sql below. The problem is it returns values that are not in the PERF_DEPT_ID or OGROUP_ID criteria. The results of the query are attached as well. Any help is appreciated! SELECT ORDER_ITEM_SEQ, PERF_DEPT_ID, OGROUP_ID, ORDER_NAME...

Hello all! I am trying to create new data in a table using a data field from another table. My IS department helped me with this following statement but it does not work and we are all scratching out heads: INSERT INTO o_alias (alias, order_item_seq, alias_seq,is_order_name) values...

Hello all! I'm new to sql and have a need to insert new data into a table. I could manually type it, but there are several hundred entries that need to be made. This is a printer assign table for all devices connected to the system. Each device needs to be added three times with the print types...

Good morning! I have a report the shows incomplete fields by provider. The problem lies when there are multiple providers for one patient, it creates conflict. I want to filter the report to where it only contains one name per provider. The data looks like this: Nurse, Nancy;Jones, Jim L...

Hello all! I am working with a date/time field in access, pulling to crystal 11. The data in the field is either a date like "11/23/2009 10:40" or the word "outlier" if it was not entered. My problem is how to convert the fields with a date present into an actual date (to do datediff calcs with...

I am new, but getting better thanks to all the great information here! I am trying to use two different fields to search for specific words and return a value of 1 if present. I then sum the field and get my total ambulance arrivals. The reason I am doing this is the data could have been entered...

I am trying to get specific text from a string that works until I get a null field. The string is: <SPAN STYLE=""font-family:Arial; font-size: 3pt""><FONT FACE=""Arial"" SIZE=""3""> <STRONG><I><U>Presenting complaint:</U></I></STRONG> EMS states: shortness of breath, worse this pm, just...