Outstanding, this is it! Thank you Mike,
Ive checked the filed in the Access table and they were text --- I of
course changed them to number and now it works outstanding.

THANK YOU FOR YOUR GREAT HELP MIKE,

Cheers,
Adnan

--
Please post all your inquiries on this community so we can all benefit -
Thank you!


"Mikeopolo" wrote:


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