Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Calling Functions in Access Queries
- Thread starter blackbri
- Start date
Without seeing your query or code it is hard to determine the problem. But here is the way I do it.
In the Query
MyField: fun_GetAnswer([tablename].[field name])
FUNCTION:
Public function fun_GetAnswer(passedValue as String) as string
The above would need to be modified to handle datatypes and multiple parameters as needed with more information I can be more specific.
Good Luck
ssecca
In the Query
MyField: fun_GetAnswer([tablename].[field name])
FUNCTION:
Public function fun_GetAnswer(passedValue as String) as string
The above would need to be modified to handle datatypes and multiple parameters as needed with more information I can be more specific.
Good Luck
ssecca
- Thread starter
- #3
- Status
