Link to home
Start Free TrialLog in
Avatar of bill201
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
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#));

Open in new window

. and there i attaching this databaseNI.mdb
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of bill201
bill201

ASKER

why i am really stupid :) , do you have an idea how much time i spent on this
Avatar of bill201

ASKER

thanks alot