using excel functions in access

  • Thread starter Thread starter jer
  • Start date Start date
J

jer

I am not sure to whom I should be addressing this so I am
sending it here and also the queries group. I saw
recently in the excel group where someone was asking
about a function that would covert dollar values in
figures to text values (e.g. 100.10 would return One
Hundred Dollars and Ten Cents) and was referred to a site
with this and other functions. Is there a way to use
this function in access. If yes, how? I recall sometime
ago some help being offered in using another of excel's
built in functions - days360()
thanks
jer
 
First go see the experts.
Copy and paste the code on this page into a new module:

http://www.mvps.org/access/modules/mdl0001.htm

Then call the function from wherever you need it:

Text1.text = English(curAmount)

where curAmount is any field defined or formatted as
Currency. The function returns a string.

Hope this is what you were looking for.
As for the other function, I would first look on the same
website - Click the Date/Time functions from the menu on
the left. - you'll see.

A wise professor once told me:
"You do not have to know all the answers, you just have to
know where to look them up."
 
Back
Top