[MS_AccessPros] Re: Access 2010 =NumWord Expression

 

Hi <your name?>

We can't help you unless you post the code for NumWord.

Also, you might like to take a look in our Files> code samples for a funtion that does the same thing. I haven't tested it for millions but if it doesn't work we can probably modify it.

Regards,
Bill Mosca,
Founder, MS_Access_Professionals
MS Access MVP 2006 - 2016
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852
My Nothing-to-do-with Access blog
http://wrmosca.wordpress.com

---In MS_Access_Professionals@yahoogroups.com, <mtamiazzo@gmail.com> wrote :

Hello,

 

I'm using the Access 2010 and my NumWord expression worked fine until I started using numbers in the millions.

 

The expression is"

 

=NumWord([Contract Amount]) & "   ******************************"

 

$494,725.00 in the Contract Amount field returns:

Four Hundred Ninety Four Thousand Seven Hundred Twenty Five and 00/100 ******************************

 

$1,175,442.00 in the Contract Amount field returns:

One Hundred Seventeen Thousand Five Hundred Forty Four and .0/100 ******************************

 

Does anyone know why?

 

Thank you.

__._,_.___

---

Posted by: wrmosca@comcast.net

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (3)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 4

• Privacy • Unsubscribe • Terms of Use

SPONSORED LINKS

.

__,_._,___