Results 1 to 2 of 2
  1. #1
    ravideep is offline Novice
    Windows 8 Access 2007
    Join Date
    Mar 2013
    Posts
    1

    convert number to text number like in cheque


    i want to know how can we convert the total which we have on report in the the text.i mean lets say total is 420$ so in that case,i want this figure in words saying four hundred twnty dollars......pls someone help me as ive been given this assignment and nw this is giving me headache as ive tried it a no. of times.

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Here is a link on how to accomplish this.

    http://www.techonthenet.com/access/f...r_to_words.php

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 10-22-2012, 02:45 PM
  2. Convert number to text
    By Bertrand82 in forum Queries
    Replies: 7
    Last Post: 10-12-2012, 01:19 PM
  3. Convert Text to Number
    By Jerseynjphillypa in forum Import/Export Data
    Replies: 7
    Last Post: 05-09-2012, 12:45 PM
  4. Replies: 2
    Last Post: 11-22-2011, 11:45 AM
  5. Convert number to fixed length text field
    By tpcervelo in forum Queries
    Replies: 1
    Last Post: 08-02-2010, 07:26 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums