Recent content by Micheleaz

You're a beautiful man! It worked!...thank you

uggggg....it didn't work. It right justified everything but didn't put the zero's in. Does it not like adding leading zero's to alpha?

I'm learning as I go and this is probably a basic question but if I have an alpha numeric field of variable lenght, i.e. AUI856Z....how to I format it so that it is 19 characters long with leading zeros, i.e. 000000000000AUI856Z.:confused:

That worked. Thanks!

so in my query, I'd type Total:format[Charges_Total],"0000000" It's giving me a syntax error. I'm learning as I go so I'm sorry if it sounds stupid.

I need to take 255.14 and make it a 7 character text field with leading zero's. I can't get the conversion to text right. It still recognizes the decimals and removes teh leading zeros. 255.14 to 0000255