Hi all Weird. I know Decimal is claimed to be buggy, but this is beyond "buggy", I think: http://stackoverflow.com/questions/31327402/cdec-in-access-sql-is-not-behaving-the-same-as-when-used-from-access-vba I can reproduce the described behaviour in Access 2013. /gustav