Removing Zeros from Output

[jstew]

I have created a query that is based off an accounting table. If the field is all numeric it pads it with about 7 or 8 zeros in front. How can I remove these zero's when I run my query. If I'm unable to do it this way then please give me some suggestions on how I can accomplish this. Thanks in advance.
jstew

 

[Aqif]

Hi

How abt trying using the Val function which goes like Val(FieldName)

let me knw how it goes.

Cheers!
ÙÇãá