Query not showing right results on form in combobox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have this query on my combobox on my form.

SELECT tblSerialInfo.SerID, tblSerialInfo.SCustID, tblSerialInfo.CustID,
tblSerialInfo.Location, tblSerialInfo.Dated, tblSerialInfo.Frame89
FROM tblSerialInfo
WHERE (((tblSerialInfo.SCustID)=[Forms]![frmCoverPage]![SCustID]) AND
((tblSerialInfo.Dated)<>Date()) AND ((tblSerialInfo.Frame89)<>"1"))
ORDER BY tblSerialInfo.SerID;


The problem is with field Frame89, which is a Option box (values 1,2,3). I
only want to show the serial record that doesn't have today's date and does
not equal a "1" in the field frame89. I show no records at all. I know I only
have one record out of 12 that hits this criteria...and the other 11 don't
show upo. why?

If I reverse the logic and make it equal to 1 I get only that record...which
would be correct, but backwards from what I want.

Hope I'm not confusing anyone? But can someone help me...I'm sure it's got
to do with the <> but I don't know how to fix it.
 
Is the Field Frame89 a Numeric Field or a Text Field?

If it is a Numeric Field, why do you compare it with the *Text* value "1"?
 
Back
Top