Recent content by uatkd1

I have two tables in a left join and i have one set of numbers that has multiple matches of a different set of numbers. For example: Qpin Lpack number (primary Key) 9555 95555555 9555 95555555 9555 95550000 9555 95550000 The table on the right has the multiple...

Ok, this is super complicated in my mind....but it could be a simple solution i am not seeing. I have two tables in a left join and i have one set of numbers that has multiple matches of a different set of numbers. For example: Qpin Lpack number (primary Key) 9555 95555555 9555...

Thank you to both of you! it worked:)

Hi Everyone, I have created a query and made a table from it, but one of my fields is showing up as a "Text" field when I create the table. I want it to show up as a "Number" field. I am using an expression to extract numbers from it and the expression i am using is: MPIN...

Thanks, I used your expression in post 4, but had to put my field name I was using from the table, Textbox7. The expression ended up looking like this: Expr3: Val(Mid([textbox7],InStr(1,[textbox7],"(")+1)) This worked! Thank you so much... this rookie appreciates the help:)

Thank you for the quick response, and the Mid function worked, but I am still getting the last parentheses. I am using MS Access. Here is the expression I put: Expr1: Mid([textbox7],InStr([textbox7],"(")+1) Here is the outcome I am getting: 31534) I want to get rid of that last ")" Do I need...

Hi Everyone, I am trying to get just the numbers from a line of text, and here is the original text: ALBANY, NY (31534). The number of digits does not change, but there are many different states in the field (ex: Minneapolis, MN (21433) so the character size will vary. here is what i have...

Thank you so much for this! I searched high and low for help on this...thank you again