Recent content by SDaccess24

All I am trying to do is an access query between the two tables. I want to find all values in the Peoplesoft table where Invoice ID field is present in the Invoice field on the Wells table. Sorry if I wasn't very specific earlier. Attached are my two tables for reference. Thanks again!

Table 1: Wells Table 2: Peoplesoft Please see Picture attached for tables. I am trying to have a Access function to find is Recond # 4 with invoice ID ABCDEF is present in the Peoplesft table and pull the corresponding Amount field. I tried instr function and it is not working :-( Thanks!!

Can you pleas help me with an example? I tried InStr([Wells]![Invoice ID],[PeopleSoft]![Invoice]) [Wells]![Invoice ID],[--> Longer String [PeopleSoft]![Invoice]) --> Shorter String that is part of the string mentioned above. No Luck :-(

I am trying to find a string as part of a larger String. Is there any Access formula I can use? Eg. Find.. ABCDEF in [ ASADFAG, ASDHJFSH, FHEWFH, ABCDEF, JKSDGFS] There is no set count of characters that I can use a mid, left, right functions. Any help is much Appreciated!