Update Query To Append Zero to front of deptid

[Denise Blum via AccessMonster.com]

I imported a table with the field deptid ?101? from an excel spreadsheet.
How can I create an update query to ADD ?0? to the front of deptid "0101" .

 

[MGFoster]

I imported a table with the field deptid ?101? from an excel spreadsheet.
How can I create an update query to ADD ?0? to the front of deptid "0101" .

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

If DeptID is a text data type column:

UPDATE table_name
SET deptid = "0" & deptid

If DeptID is a numeric data type column just format the display to show
a leading zero (use the Format property for controls):

Format: 0000

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQk2vX4echKqOuFEgEQJQSACg4k9D5iCGyXwcDD23c/SA5fayoIsAoPty
SQwQj49nP5fLWOQKTGKBbWQJ
=4+2J
-----END PGP SIGNATURE-----

 

[Denise Blum via AccessMonster.com]

That solve my problem. THANKS!!