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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Geting result set to print only Checked records 1
Retrieve Column Header for Specific Data in a Row 3
Create a yes no message on a command button on click 0
Retrieving records where yes/no data type is checked 8
Steam user spends $13,000 to get to Steam's highest level 2
Excel Macro to use cells as a autofilter 0
SUM NOT INCLUDING ALL RECORDS 4
matching a customer with a twist.. 1

Back
Top