dcsimg


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: MS-Access?

  1. #1
    Scott Guest

    MS-Access?


    I need some code help from you. In access I am trying to create a check
    writing report that shows the customer name, address, date, transaction
    reason, and amount. What I need is code to take the amount and convert it
    to a text string. For example: $253.00 shows up as two hundred and
    fifty-three dollars and 00/100.... or 10.50 is ten dollars and 50/100...

    Any idea how to do this?

  2. #2
    Paul Clement Guest

    Re: MS-Access?

    On 27 Jan 2003 18:00:30 -0800, "Scott" <soniascott@worldnet.att.net> wrote:


    I need some code help from you. In access I am trying to create a check
    writing report that shows the customer name, address, date, transaction
    reason, and amount. What I need is code to take the amount and convert it
    to a text string. For example: $253.00 shows up as two hundred and
    fifty-three dollars and 00/100.... or 10.50 is ten dollars and 50/100...

    Any idea how to do this?

    See the following link:

    http://www.mvps.org/vbnet/code/helpers/numbertotext.htm


    Paul ~~~ pclement@ameritech.net
    Microsoft MVP (Visual Basic)

  3. #3
    Larry Rebich Guest

    Re: MS-Access?

    Found this while searching Google:

    http://www.a1vbcode.com/snippet.asp?ID=1913

    Cheers,
    Larry Rebich

    More tips link to:
    http://www.buygold.net/tips

    Please:
    No personal e-mail questions :-)

    "Scott" <soniascott@worldnet.att.net> wrote in message
    news:3e35e43e$1@tnews.web.devx.com...
    >
    > I need some code help from you. In access I am trying to create a check
    > writing report that shows the customer name, address, date, transaction
    > reason, and amount. What I need is code to take the amount and convert it
    > to a text string. For example: $253.00 shows up as two hundred and
    > fifty-three dollars and 00/100.... or 10.50 is ten dollars and 50/100...
    >
    > Any idea how to do this?




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center