By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,998 Members | 2,825 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,998 IT Pros & Developers. It's quick & easy.

query calling function

P: 30

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..........
Aug 30 '12 #1
Share this Question
Share on Google+
4 Replies

Expert Mod 2.5K+
P: 3,284

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

Expand|Select|Wrap|Line Numbers
  1. SELCET Field1, Date() AS CurrentDate FROM Table1;
You can even use functions within your criteria as well:

Expand|Select|Wrap|Line Numbers
  1. "SELCET Field1, Field2 FROM Table1 WHERE Field2 =  #" & Date() & "#;"
Hope this helps!
Aug 30 '12 #2

P: 30
i want complex functions.....

i know this one .......
Aug 30 '12 #3

Expert Mod 2.5K+
P: 3,284
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?
Aug 30 '12 #4

Expert Mod 100+
P: 2,321
You could take a look at this video:
How to use a Custom Function in MS Access
Aug 30 '12 #5

Post your reply

Sign in to post your reply or Sign up for a free account.