query calling function

[prasad joshi]

hello....

i have heared that we can call a function by using access query

i dont know how to do this

can anybody give me example........ ..

[twinnyfo]

prasad,

You simply add the function to the query as one of the paramaters. Like so:

SELCET Field1, Date() AS CurrentDate FROM Table1;

You can even use functions within your criteria as well:

"SELCET Field1, Field2 FROM Table1 WHERE Field2 =  #" & Date() & "#;"

Hope this helps!

[prasad joshi]

i want complex functions.....

i know this one .......

[twinnyfo]

It is no different. Just use the same syntax and arguments required by the function......

Do you have an example that you would like to use?

[TheSmileyCoder]

You could take a look at this video:
How to use a Custom Function in MS Access