My table has a text field which contains numeric data. The data starts off with 1....etc. My question is this: How can I get the data that reads 1..... to read 01.... That is how can I add a zero to the begining of all the data that starts w/a 1 ?? I assume I'll have to state some sort of special criteria in a query. I've already tried: New field name: 0+[old field name] with no luck.