CONVERT A NUMBER TO TEXT

J

jn5519

I'm reading ales data from a Customer database in SQL 2000 where the customer
number(Primary Key) is a numeric field to update participation data to an
access database.

Unfortunately the Customer number field in access,he primary key, is text.

Using the original BASIC programming I could do:

A$=STR(A:"0000")

in order to convert the numeric data to alphanum. How can I accomplish this
in an access query?
 
V

Vincent Johns

jn5519 said:
I'm reading ales data from a Customer database in SQL 2000 where the customer
number(Primary Key) is a numeric field to update participation data to an
access database.
Click to expand...

Ah, so you're a brewmeister. :)
Unfortunately the Customer number field in access,he primary key, is text.

Using the original BASIC programming I could do:

A$=STR(A:"0000")

in order to convert the numeric data to alphanum. How can I accomplish this
in an access query?
Click to expand...

In Access, you can use

Format$(A,"0000")

to produce a 4-character string (such as "0077" if A = 77).

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
Top