Search results

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

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

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