Recent content by RayJ

Ya, thats what i was thinking as well. I may have to maintain that list manually as new systems gets added. Thanks again! :)

haha! Thanks for your help! I do have another question though. Just thinking out loud and wondering what if in the near future more systems get added to the list which may not have any special character or even different ones like (".") What would be the best approach to tackle that. So like...

I am sorry... silly me.. I was missing the space between DNA and "-" . Got it! Its good now.

Using your expression above , for some reason it is only extracting the word Oracle and coming up blank for DNA. :/ I have got the following result below using : System_Name: Left([System],(InStr(1,[System],"-"))-2) But as you can see, that expression is throwing an error "#Func!" for Oracle..

I am sorry. I should've mentioned it. I am looking to use this expression in a query for viewing purpose.

Those are the only 2 different types of string under the system field. SYSTEM (field name) ------------------ DNA-Data Oracle_DIMDW

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 using this query just for a reporting purpose. I wanted to transfer this data on an excel file without creating dups.

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