Selecting only records that are not null

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

Guest

How do I write a criteria statement for the sales column where only sales are
retrieved in the result set? My sales column is a yes/no data type. I know
that I want to use the <> to show that the sale entry is not null but I don't
know how to write the statement. Thanks.
 
I inserted the field name Sale for the asterisk and the table name after
FROM. The message "Data type mismatch in Criteria expression" appears after
hitting run button. The data type is yes/no in the table. Thanks.
 
Back
Top