(Right$(nod.Key, 5)) 1

[hoofit]

In my application, I use (Right$(nod.Key, 5)). The return I'm looking for is "PMH50" which I get with no problem. However, when there are returns like "PMH100" or "PMH1000", how is the function worded to return this?

Thank you kindly

hoof

 

[PHV]

Something like this ?
Mid(nod.Key, InStrRev(nod.Key, "PMH"))

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[hoofit]

DoCmd.RunSQL "DELETE * FROM PMInterval WHERE PMName='" & Mid(nod.Key, InStrRev(nod.Key, "PMH"))

results in a syntax error

hoof

 

[PHV]

DoCmd.RunSQL "DELETE * FROM PMInterval WHERE PMName='" & Mid(nod.Key, InStrRev(nod.Key, "PMH"))[!] & "'"[/!]

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[hoofit]

PHV,

Yup that does it. What does the extra & "'" do at the end of the function? This is the second time I've seen it.

hoof

 

[PHV]

This add the closing single quote for the text value tested for PMInterval in the SQL code:
DoCmd.RunSQL "DELETE * FROM PMInterval WHERE PMName=[!]'[/!]" & Mid(nod.Key, InStrRev(nod.Key, "PMH")) & "[!]'[/!]"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[hoofit]

Yes I see it, thank you