Hello all,
I'm having a bit of trouble trying to understand why the following two queries return empty sets:
----------------------------------------------------------
SELECT *
FROM A, B
WHERE A.ActualRelease <> B.ActualRelease;
----------------------------------------------------------
SELECT *
FROM A, B
WHERE A.ActualRelease = B.ActualRelease;
----------------------------------------------------------
To the best of my understanding, two values are either equal or not equal - so I should get a recordset for one query or the other.
1. "ActualRelease" is set up as a text field in a table.
2. Table A is a table containing historical data.
3. Table B is a temp table, created to store incoming data temporarily.
4. Both tables A and B share some common column names.
5. Ultimately, what I want to do is compare values in a column between tables A and B. If values are NOT equal, update table A's "ActualRelease" with table B's "ActualRelease" value.
I've managed to put together an Update query, that works only sometimes. I've narrowed down my problem to the above queries. Though I consider myself a novice at this, I suspect there is a problem in the way Access evaluates null fields versus fields that had values that got deleted. Let me explain:
1. When I first ran my update query, Table A's "ActualRelease" field was updated with a correct value, based on Table B's "ActualRelease" value.
2. Because I wanted to retest the query, I went to Table A and deleted the value in "Actual Release".
3. When attempting to rerun the update query, Access did NOT return a recordset for TableA.ActualRelease<>TableB.ActualRelease.
Any help/suggestions?
Thanks!!!