Your numbers being left-aligned means that they are either text at
source, or being treated as text somewhere along the way.

I suggest you check the field in the table definition, both in the
Access table itself, and open the query, go to File, Table Definition,
and search for the table and field entry there.

Both definitions should be a numeric type. Post back the result.

Regards
Mike


--
Mikeopolo
------------------------------------------------------------------------
Mikeopolo's Profile: http://www.excelforum.com/member.php...o&userid=18570
View this thread: http://www.excelforum.com/showthread...hreadid=563951