Rounding Difference between two tables?!

A

arran1180

I have two table with info pulled from 2 diffrent excel files. Each table has
a CASH field (say, cash1 and cash2). I am trying to reconcile the two tables
by matching the cash values. Currently i have a relationship between Cash1
and cash2, and i want to be able to query the tables to provide a list of all
entries that are matched.

I can do this - but some enteries are different by tiny fractions (8 dec
places), and so are not retrieved. - is there any way round this? i have
tried using the ROUND function on the Cash1/2 fields, but still no joy...

any advice greatly appreciated!!!
 
B

Brendan Reynolds

SELECT Table1.*, Table2.*
FROM Table1 INNER JOIN Table2 ON Abs(Table1.TestDouble - Table2.TestDouble)
< 0.01;
 
A

arran1180

thanks, you'll have to excuse my SQL ignorance - but what do i put in for
Testdouble? I have made a new query based on the below (although rather than
tables i use previuos queries), but i'm asked to input a parameer for the
..testdouble part?
 
B

Brendan Reynolds

As Doug says, replace TestDouble with the name(s) of the fields on which you
want to join the tables.
 
Top