it works! I didn't know that was possible. kind of new at this as you can see. Only thing is that I have field 3 with:

[OBG_NO] & "" & [OBL_NO] that combines field 1 &2

Because once this query goes into a table i'm running another query based off those numbers...

here are my new results

field 1 field 2 field 3
0000000012 0000008548 128548 <-- I formated that field as well but that doesn't change anything. Any ideas???