extract number in string between parentheses

[deb]

In access office 365

In a query...
I have a field with a string that varies in length, where the end is always a number between parentheses.

example
walk to work (4)
eat a salad with water (7)

How can I extract the number between the parentheses using a query.
4
7

Thank in advance

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/micro...-enterget-string-post5230856.html#post5230856

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

I had responded to your thread over there, but you did not reply back.