Dec_Sec Function?

[zowmaster]

Hello,



I am working on updating a query and am stuck on one part; in the Select statement it is written as Dec_Sec([Field1],[Field2]). Field1 contains a code (max 8 characters) and Field2 contains a one digit letter code.

This code creates a new field (Group by creates a new field Security Codeec_Sec([Field1],[Field2])). The new Security Code field has word designations like Bonds, Bills, etc. My question is what is this Dec_Sec code? I cannot seem to find it anywhere, what is it doing and where can I see the logic behind it?


Many thanks,
zowmaster

[RuralGuy]

Search your project for this procedure. It is not an MS Access function so it is probably a UDF (User Defined Function).

[ranman256]

yes, its custom. press Alt-F11 (VBE), then Ctl-F (find)
set to CURRENT PROJECT

to find that function.

[zowmaster]

Awesome, you guys are great. That gave me exactly the info that I needed, was just being dense I guess.. Thanks again!

[RuralGuy]

You're very welcome. I marked the thread as Solved for you.