Search results

I checked my reference library and found what I needed to make this work. Thanks for your help.

Here is the SQL View of my query: UPDATE tblMissingNumbers SET tblMissingNumbers.MissingNum = Format([MissingNum],"000000"); This gives me an error message: Wrong number of arguments used with function in query expression 'Format([MissingNum],"000000") I'm using Access 2000, does this have...

I have a text field in my table called MissingNum with several thousand records. The total number of digits in this field should always be six. The leading zero(s) have been dropped. I would like to run an update query to add these zero(s). I tried: Format([MissingNum]),"000000") in the...