I'm trying to add a zero to the front of a field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

and it isn't working. I'm trying to design an update query and this is the
function I am using: DepId:"0"+[Dep_Id].

Anyone have any suggestions on what is wrong with this function or other
ways of doing this?

Thanks.
 
LisaK said:
and it isn't working. I'm trying to design an update query and this is the
function I am using: DepId:"0"+[Dep_Id].

Anyone have any suggestions on what is wrong with this function or other
ways of doing this?

Thanks.
Click to expand...
Not sure why you would do this but you might want to try something in
the format field of the fields property. This will work if the data type
is numeric. In the format field do something like 0###

if it is is a text field, I am not sure why your solution is not working .

--
Frederick Wilson

_____________________________________
for multimedia design services visit
http://www.legalanimatics.com
 
I bet that it's trying to add a 0 to Dep_Id. Instead of the + sign, use an
ampersand & .

DepId:"0" & [Dep_Id]

You might also be seeing a circular reference error. If so:

DepId0:"0" & [Dep_Id]
 
and it isn't working. I'm trying to design an update query and this is the
function I am using: DepId:"0"+[Dep_Id].

Anyone have any suggestions on what is wrong with this function or other
ways of doing this?

Thanks.
Click to expand...

What's the datatype of Dep_ID? If it's a number, then what you're
doing is a non-operation: the numbers 123, 0123, and 0000000000123 are
all the exact same number.

John W. Vinson[MVP]
 
Back
Top