Help with a number field converted to text filed

[Dave]

In a query I want to take a Table Field - Employee Number and covert it to a
new Field EmplID which is text.

I wnat the Field records to be 6 places.

I have not been able to figure out how to input zeros.

Ex 123456 > "123456"

Ex 3456 > "003456"

Can you help with this?

Thanks Dave

 

[Brendan Reynolds]

UPDATE tblTest SET tblTest.TestText = Format$([TestNum],"000000")
WHERE (((tblTest.TestNum) Is Not Null));

Replace 'tblTest' with the name of your table, 'TestNum' with the name of
your employee number field, and 'TestText' with the name of your text field.

 

[fredg]

In a query I want to take a Table Field - Employee Number and covert it to a
new Field EmplID which is text.

I wnat the Field records to be 6 places.

I have not been able to figure out how to input zeros.

Ex 123456 > "123456"

Ex 3456 > "003456"

Can you help with this?

Thanks Dave

NewID:Format([OldID],"000000")

 

[Dave]

Thank you!

I am off and running

Dave

UPDATE tblTest SET tblTest.TestText = Format$([TestNum],"000000")
WHERE (((tblTest.TestNum) Is Not Null));

Replace 'tblTest' with the name of your table, 'TestNum' with the name of
your employee number field, and 'TestText' with the name of your text
field.
--
Brendan Reynolds (MVP)

In a query I want to take a Table Field - Employee Number and covert it
to a new Field EmplID which is text.

I wnat the Field records to be 6 places.

I have not been able to figure out how to input zeros.

Ex 123456 > "123456"

Ex 3456 > "003456"

Can you help with this?

Thanks Dave

 

[Dave]

Thank you for the help!!

In a query I want to take a Table Field - Employee Number and covert it
to a
new Field EmplID which is text.

I wnat the Field records to be 6 places.

I have not been able to figure out how to input zeros.

Ex 123456 > "123456"

Ex 3456 > "003456"

Can you help with this?

Thanks Dave

NewID:Format([OldID],"000000")