SQL "NOT IN" doesn't function as expected (refresh)

Correct behaviour can be restored by changing the SERIAL_NUMBER in the
INSTALL table to be a plain text box rather than a LOOKUP table of values
from the PORD table. Upon changing, the values stored in the SERIAL_NUMBER
field suddenly change to some unrelated digits.

Since this behaviour is clearly incorrect, could someone with a MVP tag
please report it as a bug? SQL queries on a field should be returning the
field's value, not a reference number.

As for my db? I'll have to go with a textbox. It isn't the functionality it
SHOULD have been, but it'll do

"Farkyss" wrote:

You can download the db with some junk data in from he
http://www.clanimperium.net/testdb.accdb

"orange via AccessMonster.com" wrote:

Farkyss wrote:
Did your values in the INSTALL table come from PORD via a lookup table?
That's the issue as I see it.

SELECT SERIAL_NUMBER from PORD pd WHERE pd.SERIAL_NUMBER = "999789";

[quoted text clipped - 39 lines]
and
SELECT SERIAL_NUMBER from INSTALL inst WHERE inst.SERIAL_NUMBER = "999789";
No, I simply typed them in. That's part of why I suggested some table
structures or a sample database to help with solution.

--
Message posted via http://www.accessmonster.com

.