Tags: access, asecond, column, convert, create, database, microsoft, mysql, number, oracle, reference, sql, table, text, thattable, values

Convert Number to Text!

On Database » Microsoft Access

1,967 words with 1 Comments; publish: Sun, 01 Jun 2008 15:36:00 GMT; (25060.55, « »)

You could create a table with the values 30 to 1000 and a

second column with the A B C D E F. Then reference that

table when necessary

Eric

>--Original Message--

>Dear All,

>I have a Query in which you can find a columns with

numbers, from 30 to 100,

>I want these numbers to be converted in to letters (A, B,

C, D, E, F)

>according to this,

>100 : 95 => A*

>94 : 85 ==> A

>84 : 75 ==> B

>74 : 65 ==> C

>64 : 55 ==> D

>54 : 50 ==> E

>49 : 30 ==> F

>0 ==> N/A

>The letters should appear on a report.

>I tried to use

(http://www.mvps.org/access/modules/mdl0001.htm) but it was a

>little bit difficult to know all the combination of

numbers especially that

>I might have some fraction 84.3 so maybe someone can help

me with it.

>Thanks

>Alex

>

>.

>

All Comments

Leave a comment...

  • 1 Comments
    • Thanks, I know this, but I dont is the best thing to do, I think it is

      better to make a module and apply it to the report.

      If no one have an aswer I'll use your idea.

      Thanks alot,

      "Eric Blitzer" <anonymous.ms-access.todaysummary.com.discussions.microsoft.com> wrote in message

      news:1ffe01c4fd60$d89f9000$a401280a.ms-access.todaysummary.com.phx.gbl...[vbcol=seagreen]

      > You could create a table with the values 30 to 1000 and a

      > second column with the A B C D E F. Then reference that

      > table when necessary

      > Eric

      > numbers, from 30 to 100,

      > C, D, E, F)

      > (http://www.mvps.org/access/modules/mdl0001.htm) but it was a

      > numbers especially that

      > me with it.

      #1; Sun, 01 Jun 2008 15:38:00 GMT