MS Access Functions

[gblack]

It use to be (in Access 97) that the help would list the functions that you can use in Access, with examples...However, this is not the case in 2000 that I can see. Whenever I need help, if i do not know the exact function I need, I am out of luck.

So, I have tried to use the Microsoft Help package...but that shows EVERY FUNCTION KNOWN TO MAN. Meaning Excel functions, MSSQL Functions VB Functions and C++ Functions. Many of these do not work in Access (at least in the GUI sections).

So my Question is:
Is there an easy way to refernce a list of all the functions that work in Access?

I found this site:

http://www.filex.com/htmlhelp/traxhelpMS_Access_Functions.html

But I think it's dated or incomplete because I know of a few functions which are missing from the site.

Is there anyone who knows how to get a listing of ALL MS Access functions...or better yet a listing of functions and examples of how to use them???

This would be a great help to me.

Thanks
Gary

 

[ReAn]

Make a form, make a text box, goto properties, goto data tab, click ... on Control source, select functions, open rollout, select Access-Functions

Read

Then

open up the vba code for the form, press f2, browse.

 

[gblack]

on Control source, select functions

Got this far: Control source, select functions

but I didn't see anything called open rollout. Am I being stupid, or is this something you have to set up some how?

 

[Pat Hartman]

I made a partial (over 200 functions) list of the functions I found. I added a category code to group the functions so if you're looking for a math function, you don't need to look at all the aggregate, domain, string, etc. functions.

Access Function List

 

[gblack]

Thanks!

This is exactly what I am looking for...

 

[DennisTheMenace]

What is the simplest way to do math formulations in Access? I need to subtract one date field from another in order to come up with the number of days between them and show the answer in either a table, report, or form.

This is a simple function in Excel but I can't seem to find a way to do it in Access. I guess this shows what a novice I am...

Dennis

 

[SarahO]

Try the following - Not sure if this is what you want but this subtracts the ActualStartDate from the TrackingStartDate and will do it in "Working Days" i.e. it won't include weekends or because I have a tbl_Holidays it also does not include public holidays either.

NumberOfWorkingDays: IIf(IsNull([ActualStartDate]) Or IsNull([TrackingStartDate]),Null,[ActualStartDate]-[TrackingStartDate]-(DateDiff("ww",[TrackingStartDate],[ActualStartDate],7)-(Weekday([TrackingStartDate])=7))-(DateDiff("ww",[TrackingStartDate],[ActualStartDate],1)-(Weekday([TrackingStartDate])=1))-DCount("*","[tbl_Holidays]","[Holiday] between DateValue('" & [TrackingStartDate] & "') and DateValue('" & [ActualStartDate] & "')"))
Regards
Sarah

 

[DennisTheMenace]

Thanks Sarah, I will try that.
Dennis

 

[DennisTheMenace]

Sarah-
I didn't use your exact SQL statement but what you gave me definately put me on the right path. Thanks again!

Pat-
Your function list is pretty amazing. Thank you for sharing that!

I am learning Access the hard way... as I go. This is no way to learn correct syntax...

Dennis