Drop Preceeding zeros on Report

[y2k]

I have some make-table queries which provide the source for some reports. The source for the queries is linked to another database which I have no control over. One field (age) is always displayed with five digits. So if the age was 19 - it would display 00019. This isn't a problem in the qureies, but when we're printing the reports I'd like to drop the preceeding zeroes so that the report will only say 19 rather than 00019. How can I do this on the report?

Any suggestions?

 

[Chris66]

Could you, instead of bring the age field over in your "MakeTable" query, create a new field called "Age2" which would be an equation made up from the orginal Age field * 1. I would think that would store the age as a 1 or 2 digit field. I am sure there is an easier way but till then, try that.

 

[antomack]

Just set the control source of the age field to
CInt([YourAgeField])

 

[y2k]

Great Posts... thank you both. That's solved my problem