Unmatched Query Check

[Guest]

Ok, i have this issue. Im checking the data from Table A to see if it matches
Table B. I am using the Unmatched Query Wizard. Now both tables have money
values
but the difference between both tables are how the cents are being presented

Table A is showing 100.20
Table B is showing 100.2

So when im running the unmatched query, it is stating that this is an
unmatched. How can have the database see this as the same value.

 

[Arvin Meyer]

Make sure that the field in Table B is formatted with 2 decimal places or
that both are formatted as currency.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access