Using user defined function in SQL statement against Access database

Hey,

I have an SQL statement that has a function in it that I'm trying to run from an ASP.net page and I keep getting the error: 'Undefined Function convert1 in Statement.'
Here's the SQL statement:
Select * From[Listings-Residential] where field5 >= 100000 and field5 <= 120000 and (((convert1([field15]))>= 3)) and (((convert1([field16]))>= 2))
I have the function convert1 defined in both the asp.net page and within the Access database. How can I get this to work??

Where is the code for the function "convert1"? If it's in the ASP pge, then you can't call it as part of the SQL. You'd call it like:

SQLString = "SELECT * FROM bar WHERE foo= " & convert1(somevalue)