Error in queries PVP iquals

[Javier VFM]

Hello:

I have the following mistake on having realized a queri in two tables to see
the field pvp that are different, of 800 records there go out for me 144 that
are different but I can see that almost they all are iguaeles and not which
is the mistake if I put> then 5 coincidental fields go out for me, but if I
put> or <> you go out for me 144 records but I verify that the pvp are igules
in almost all. The fields are a text of 7 digits, I have not tried to make
them numerical and either. I use to see 2003.
Someone knows the motive. Thank you.

 

[Michel Walsh]

If you try to find the records in tableA which are not in tableB (by
comparison made on field "pvp"), try using the query wizard, which will
produces something like:

SELECT tableA.*
FROM tableA LEFT JOIN tableB
ON tableA.pvp = tableB.pvp
WHERE tableB.pvp IS NULL





Using an inner join and <> is NOT the way to go, since almost every record
from tableA will probably find a least one record, in tableB, for which its
pvp value will differ.





Vanderghast, Access MVP