bill201
asked on
why a innter join query on microsoft access don't give me one record match this criteria
hi
i have a microsoft access 2016 database that contain two tables
one table with the name "IR" and the other table name is "AR". every table contain 4 records and they records are identical on the two tables. but the problem is that on a query (that i named query 1) that i create to find identical records it's just find a match on 3 of the 4 records and i don't see any reason why the query does not see the matching on record 4 also.
this is the code on the query
i have a microsoft access 2016 database that contain two tables
one table with the name "IR" and the other table name is "AR". every table contain 4 records and they records are identical on the two tables. but the problem is that on a query (that i named query 1) that i create to find identical records it's just find a match on 3 of the 4 records and i don't see any reason why the query does not see the matching on record 4 also.
this is the code on the query
SELECT AR.Price, AR.CheckNUm, AR.PayDate, IR.Price, IR.CheckNUm, IR.PayDate
FROM AR INNER JOIN IR ON (AR.Price = IR.Price) AND (AR.CheckNUm = IR.CheckNUm) AND (AR.PayDate = IR.PayDate)
WHERE (((AR.PayDate) Between #1/1/2015# And #12/31/2015#));
. and there i attaching this databaseNI.mdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks alot
ASKER