Link to home
Start Free TrialLog in
Avatar of hidrau
hidrauFlag for Brazil

asked on

is it possible to create a function in access and use it in a query?

Hello guys

I'd like to know if it is possible to create a function in access and use it in my query.

if so, could you give me an example? Or a link where I can study this.

thanks
SOLUTION
Avatar of Brian Crowe
Brian Crowe
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Yes, it's pretty straightforward.  Just create a Public Function in a Module and use it in your query passing any of the fields as parameters you have defined.

I you give a little more specifics ... we can help you more precisely.

ET
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of hidrau

ASKER

Thanks a lot for your help