Hello i have a column with fields. Each field is a 4digit number. ex: 4465. I want my query so that it adds a "00" to the front of all my numbers. How do I do that..? Thanks!!
Add "00" to the front of all the values in my column???
Competent Performer
Windows XP 
Access 2000
Hello i have a column with fields. Each field is a 4digit number. ex: 4465. I want my query so that it adds a "00" to the front of all my numbers. How do I do that..? Thanks!!
Competent Performer
Windows XP Access 2000
Ex: should show 004465
Competent Performer
Windows XP Access 2000
i have this so far, but the zeros will nto appear
AMR_AIS_Num2: Format("00"+[AMR_AIS_Num])
Competent Performer
Windows XP Access 2000
nevermind, solved. used Format([Column],"000000")
update query - to replace "name" with paralell info in the next column which is Field
Apply Dlookup "automatically" on an entire column
Multiple "Control Source and Bound Column" ???
Posting Permissions
Reply With Quote