format number in query

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

I formatted some numbers in a queary using format(exression,"#,###")
provide comma separators. problem is now all the numbers align to the
left and I want them to align right. Any ideas?
 
If you format a number, it then becomes a string. That's why the are aligning
left. You can specify the alignment of text field in reports and forms.
 
Back
Top