Recent content by roc100

I can't thank you enough DrallocD! For some reason the code I was using would not work with the table that is linked to my database. The code you gave me worked! This has made my life so much easier. Many thanks to everyone for your help.

Hi, I am able to use the ASC function to get the ascii value of the first character in my string. How do I use it to get the value of a character that is in the middle of the string? For example; I am trying to find the ascii value of the space in the middle of this string "ABC 123". Thanks...

Thanks very much, this is very helpful. Can you please show me how to use "Chr(theAciiValueYouFound)" in my function?

The original data is "street 123". The function should return "street". Thanks again.

The code should return all values prior to the last space in a string. For example: "Street 123" returns "Street". When I use this expression in a query utilizing a table that is linked to the database, it returns "Street 123". When I use this expression in a query with a table that I have...

Thanks I will be sure to do that in future posts. I tried the function and it does work in the table I created within the database, but not in the table that is linked from another source. Any suggestions?

Hi, I have this great function that works great if I create the table from scratch in the database. The problem is that I need it to work on a table that is linked into my database. For some reason the same function will not work if I try to use it in a query with a table linked to the...

Unfortunately this eliminated other data I need such as "AIR DISC". I need the DISC part to be left in there. I am going to go with the first function you gave me and see if I can eliminate some of the exceptions at the time of data entry. I do wish there was a way to create a table with two...

Sorry about that. Many thanks to you all for taking the time to help me out. "FM3 2057557" needs to match with "FM3". "FM4 2057554" needs to match with "FM4" "FM7 DISC 2061034" needs to match with "FM7 DISC" There are a few of these. When I use the function to pull all text prior to the...

Thank you so very much this works great! There are some exceptions (of course!) Is there anyway around them? My main concern is distinguishing the ones with "DESC" after a number. Thank you!! AC5 DISCAFM3 2057557FFM4 2057691FFM5 2062239FFM5 DISC 2061005FFM6 2062999FFM6 DISC 2059269FFM7...

Is there a way to pull out the information I know will be there using an exact match? I know that there will be "CMA" in the value. CMA 12345 CMA 11111 CMA 22222 Is there a way to pull out the "CMA"? I could then match them up to the other table. I would need to do this for multiple...

Hi again, I understand the concept of the matching table which normally would work. However the problem is that I will have to put the new data that changes every day into the matching table and tell it what to match to. So "CMA 12345" matches with "CMA". The next day "CMA 11111" will need...

I will give this a try. Thanks again for all of your help -

Thanks for your help. The problem is that one of the sets of data that I am comparing changes every time I run the query (daily). For example: CMA1234 the next day I run the query will be CMA1111 and there are about 100 different values like this like OMG1234 and PIN1234. So creating a...

Hi all, I am trying to do a left join comparing two descriptions. It works great however there are several fields that are only a parital match. I have tried using a LIKE statement in the Where field, but it will not return the results I need. I am using the join to compare two Desciption...