Query problem

[Guest]

This is supposed to leave me with numbers 1 to 12 that have not been used
i.e. if 3 has been used the combo box should only show 1,2,4,5 etc

Pairs is a tbl with numbers 1 to 12

TestRecord is a tbl with 12 empty records

SELECT Pairs.Pairs, TestRecord.TestRecord
FROM Pairs LEFT JOIN TestRecord ON Pairs.Pairs = TestRecord.TestRecord
WHERE (((TestRecord.TestRecord) Is Null));

Hope that made sense

 

[Douglas J. Steele]

Can you give an example of what's in Pairs and TestRecord? The idea of "a
tbl with 12 empty records" doesn't really make sense to me.

 

[Guest]

if you look further down to the post titled Help this might give you some
idea of what i am trying to do.

 

[Douglas J. Steele]

Answering my question about what do the two tables look like would go much
further to explaing what you're trying to do!

 

[Guest]

Ok
Pairs Table

PairsID Pairs
1 1
2 2
3 3
.. .
.. .
12 12

TestRecord Table
TestRecordID TestRecord
1 (Empty Field)
2 ""
3 ""
.. ""
.. ""
12 ""

 

[Douglas J. Steele]

Do you set the value of TestRecord somehow so that sometimes it's not empty?
(I'm assuming it's actually Null, not a zero-length string as you've
indicated). If not, then your query will always return the same thing.