I have a field called "UnitNo" that I have combined with another field called "Mark" into one field called "MarknUnit". These are identifiers to rail cars that I am tracking. I need to relate these records to another table. The problem is that quite a bit of the UnitNo records are incomple (they should be six characters long, many of which are only four to five characters long). I need to update the incomplete records by putting 0s at the beginning of the record (ex. 3466 to 003466). This will allow the record to relate. How do I do this with an update query? Thanks in advance. [sig][/sig]