Search results

I am working with a table that has a field name System where the values are like this: DNA-Data Oracle_DIMDW I only need to capture the values just before the "-" and the "_". What i am expecting is "DNA" and "Oracle". I have managed to capture the string "DNA" using the code below...

I am trying to build a query from a table (Tbl_XYZ) that will give me the information for the primary key all in one row rather then creating dups for that primary key and showing up with multiple rows. Example below.( this is just a sample) Account Number System_Name Table_Name 012345 DW...