format number in query

[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?

 

[Jerry Whittle]

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.