need to add leading zero's

[pduncan]

I have a query with this in the field position:

batch: DLookUp("[ZbatchNo]","tblZbatchNo","ZID=1")

How can I add 5 zero's to the front (i.e. left) of this number?

thanks

Thanks, PDUNCAN
Memphis, TN - USA
When I die, I want to die like my grandfather-- who died peacefully in
his sleep. Not screaming like all the passengers in his car.

 

[PHV]

Something like this ?
batch: "00000" & DLookUp("[ZbatchNo]","tblZbatchNo","ZID=1")
Or this ?
batch: Format(DLookUp("[ZbatchNo]","tblZbatchNo","ZID=1"),"00000")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244