format data where combined txt & numberfields; access 2002 rpt?

[Guest]

I'm trying to get my report to combine two data fields into a single output
that contains bioth text & numeric data in a given format. "AAA000"
When I combine them the numeric defaults to the "999" format.
Instead of getting "ARE001" it reports "ARE1".
Any suggestions?

 

[John Vinson]

On Tue, 14 Nov 2006 15:39:57 -0800, Peter New Zealand <Peter New

I'm trying to get my report to combine two data fields into a single output
that contains bioth text & numeric data in a given format. "AAA000"
When I combine them the numeric defaults to the "999" format.
Instead of getting "ARE001" it reports "ARE1".
Any suggestions?

Use the Format() function to specify the numeric format:

[Textfield] & Format([numericfield], "000")

John W. Vinson[MVP]