LeeSmith Registered User. Local time Today, 17:00 Joined Mar 17, 2006 Messages 27 Mar 13, 2007 #1 Hi there Im working on an update query to add 2 zeros to the front of a field where it is less than 8 digits long. I'm not sure how to go about this, can anyone help me out? Cheers
Hi there Im working on an update query to add 2 zeros to the front of a field where it is less than 8 digits long. I'm not sure how to go about this, can anyone help me out? Cheers
M MStef Registered User. Local time Today, 17:00 Joined Oct 28, 2004 Messages 2,250 Mar 13, 2007 #2 Not via query, but FORMAT properties.
LeeSmith Registered User. Local time Today, 17:00 Joined Mar 17, 2006 Messages 27 Mar 13, 2007 #3 Ah, sorry, knew there might be a better way of doing it. What do I have to do to the properties to add the 2 zeros to existing data?
Ah, sorry, knew there might be a better way of doing it. What do I have to do to the properties to add the 2 zeros to existing data?
M MStef Registered User. Local time Today, 17:00 Joined Oct 28, 2004 Messages 2,250 Mar 13, 2007 #4 put; 00000000 in table field and form field.
LeeSmith Registered User. Local time Today, 17:00 Joined Mar 17, 2006 Messages 27 Mar 13, 2007 #5 I did this on a test copy of my db and it deleted lots of records
M MStef Registered User. Local time Today, 17:00 Joined Oct 28, 2004 Messages 2,250 Mar 13, 2007 #6 you made something wrong.
