Increment Letters

Posted on 2007-10-04
Last Modified: 2012-05-05
Is there anyway to increment letters apposed to numbers. So instead of 1,2,3 I would have one,two,three
Question by:andyb7901
    LVL 119

    Expert Comment

    by:Rey Obrero
    you may need a table to do that..
    not actually incrementing number words, but translating the incremented number..

    where do you want to do this?
    LVL 33

    Expert Comment

    You might take a look at the funciton mentioned here:

    LVL 119

    Expert Comment

    by:Rey Obrero
    see this link
    How to Convert Currency or Numbers into English Words

    LVL 5

    Accepted Solution

    Try this:

    Dim iCount as integer, strChar as string

    for iCount=1 to 26
    strChar=str(asc("@" + iCount)
    print strChar

    Or this:

    Dim iCount as integer, strChar as string

    for iCount = 1 to 25
    strChar=str(asc(strChar) +1)
    print strChar

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now