Formula Help

[bstack10]

Hi Guys,

Very new to Access having an issue with a formula I have working in Excel correctly. But when I try to transfer it to Access its not working out.

I have a set of phone numbers which vary in length I want to extract the numbers between the first two "-" see example below

555-63738-939 (I would like to get "63738")
55-00393930-0303 (I would like to get "00393930")




Here is the excel version of the formula
=MID(A1, FIND("-",A1)+1, FIND("-", A1, FIND("-", A1)+1)-FIND("-",A1)-1)

In Access I have gotten the formula working up until the point that it grabs what is after the first "-" but when I try to add additional pieces to the formula that is where I am having problems

Here is the Access formula that I have
MidSectionPhoneNumber: Mid([Phone],(InStr([Phone],"-")+1))

[cyanidem]

Mid([Phone], (InStr([Phone], "-")) + 1, (InStrRev([Phone], "-")) - ((InStr([Phone], "-")) + 1))

[bstack10]

Mid([Phone], (InStr([Phone], "-")) + 1, (InStrRev([Phone], "-")) - ((InStr([Phone], "-")) + 1))

Thanks very much!! does as is required