match number fields

[deb]

Access 2010

I have two fields that contain numbers. I need to check to see if they match.
The numbers sometimes vary in the number of decimal places. How can I match the fields for any thing after the 2 decimal places...
i.e.

Match field one 1.234 to field 2 1.23404736


in other words ignore any decimals after the second decimal

 

[Joe4]

You can use the ROUND function, i.e.

IIF(ROUND([Field1],2)=ROUND([Field2],2),"Match","No Match")