Re: How would my database write a number with letters?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Brendan Reynolds (brenreyn)
Date: 01/06/05


Date: Thu, 6 Jan 2005 13:57:42 -0000

Check out the code at the following URL ...

http://www.mvps.org/access/modules/mdl0001.htm

While the code is designed to work with currency values, I expect it could
be adapted for other numeric values.

-- 
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
"AndreasM" <AndreasM@discussions.microsoft.com> wrote in message 
news:A86B7D6A-0D1F-4D95-A423-CFD24DE56DA2@microsoft.com...
> if could you help me....I make a database and i dont know how to do it...
> In a Querie a hava a result.. f.e. 3 or 6,7, and i want to make a field 
> wich
> it has this number but written by letters, 3 from our example as three 
> etc...?
> 


Relevant Pages

  • Re: DoCmd.openform criteria using a variable
    ... The spammers and script-kiddies have succeeded in making it impossible for me to use a real e-mail address in public newsgroups. ... E-mail replies to this post will be deleted without being read. ... Any e-mail claiming to be from brenreyn at indigo dot ie that is not digitally signed by me with a GlobalSign digital certificate is a forgery and should be deleted without being read. ... When the form> opens ...
    (microsoft.public.access.formscoding)
  • Re: New line in Query
    ... me to use a real e-mail address in public newsgroups. ... E-mail replies to ... GlobalSign digital certificate is a forgery and should be deleted without ... >I want to have a new line between address and city in the select query ...
    (microsoft.public.access.queries)
  • Re: Is there an Add-In for the VBA editor that configures the editor .
    ... me to use a real e-mail address in public newsgroups. ... E-mail replies to ... GlobalSign digital certificate is a forgery and should be deleted without ... "Ronan" wrote in message ...
    (microsoft.public.access.modulesdaovba)
  • Re: Database designs
    ... me to use a real e-mail address in public newsgroups. ... E-mail replies to ... GlobalSign digital certificate is a forgery and should be deleted without ... > a CD and DVD database and am too lazy to recreate the wheel. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: NZ function
    ... the intermediate calculation may be evaluated as text. ... > Thanks, the values that I use are currency only, no text, and still ... >> me to use a real e-mail address in public newsgroups. ... >> GlobalSign digital certificate is a forgery and should be deleted without ...
    (microsoft.public.access.formscoding)