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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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]
 
Back
Top