Search results for query: *

Hi all, I have created queries (50+) to capture below information and these information is in one single table. Only thing different is column name. I used query option, because I have not figured it out different way. SELECT Sum(Abs([RN1]="Yes")) AS Yes...

I'm new with forms. I have couple of forms and I need to be able to navigate different forms, pages, and tabs based on which command button is clicked. Form1: Page1...page5, page3, tab1...tab10, cmd1...cmd3 Form2: Page1...Page5, page3, tab1...tab10, cmd1...cmd3 Tried several options but so...

I have a field that collects visit date & time but it is stored in varchar2 format 'hh24mi ddMonYYYY' and I thought this function will solve the problem but it doesn't. create or replace function getfulldt(x in varchar2) return varchar2 is y Date; begin if x is y := to_date(x, 'hh24mi...

Please help! These are samples of medications for one patient, varchar2(4000), and I want to be able to count how many times 'qd' are used. meds ----- Thiamine 100mg qd Gabapentin 1200mg qAM Gabapentin 1800mg qPM Zantac 300mg qd Lopressor 50mg bid Finasteride 5mg qd Niacin 1000mg qd...

Please help! These are samples of medications for one patient and I want to be able to count how many times 'qd' are used. meds ----- Thiamine 100mg qd Gabapentin 1200mg qAM Gabapentin 1800mg qPM Zantac 300mg qd Lopressor 50mg bid Finasteride 5mg qd Niacin 1000mg qd Ferrous Gluconate 325mg...

I'm not sure what is available to accomplish this: 1. I need to be able to search if any of view has specific field name such as CustID. 2. If there is CustID, I would like to search all columns that has certain strings like '%xxx%'. 3. at last, I need to be able to identify list of...

Please help. This is the current format: line1 rn_type r_staff r_hrs r_shift line2 contractor name1 12 1 line3 lvn_type l_staff l_hrs l_shift line4 contractor(o) name1 8 2 If line4 is null(all 4 fields), I do not want line3 & line4 to be...

Please help! I'm not sure what is the best way to solve this issue. I have two date columns (FROM, PRESENT). With that I need to calculate number of days. (For Example: This is Jan 04 data.) Slight problem is that if PRESENT date is >= '1 Feb 04' then I need PRESENT field to be '31 Jan 04'...

Need help on my script. I'm trying to capture all data but doc_table key column(stored date) is messed up and I need to somehow to capture the data that does not meet the critieria. For example, if stored date (key) is documented before entertime than I want key field to be entertime. Thanks...

Need your experties. I'm not sure what options are available for the task I need to accomplish. I need to run simple query every hour for next few weeks and result need to be insert into temp table. I heard that this can be done thru batch file. Collecting fields are: sysdate, field1, and...

Please help.... I have dirty data need to clean up before I can calculate. First 2 digits are hours and last 2 digits are minutes. This column's data type is in varchar2 and this is how data is stored: 1. 1234 2. null 3. abcdefg 4. 12 What I would like to do is that if the field is not...