Query Criteria

[Danielle17]

I'm trying to run a query using a criteria expression. The query contains all the info for a 'customer phone book'. In the table that the query is run from there is a column called RepCode. If that column has a 999 in it then I don't want that record displayed in the query. I've tried using Not "999" and Not 999. But if I do that then it doesn't retrieve the records where the column is blank.(If the customer doesn't have a repcode the column is left blank)I think this has something to do with null values. So I tried Not "999" and Is Not Null....that returns all the previous records and just one of the records with a null value. Anybody know what I'm doing wrong?

 

[Danielle17]

opps...I meant to say Not "999" and Is Null.....that returns zero records

 

[dawnd3]

Hi Danielle, try this: Not "999" Or Is Null

Let me know if that helps

Dawn

 

[dawnd3]

when you use "and" you are asking it to return records where the value in the field meets both criteria..."or" will return values when it matches any of the criteria.

 

[tlbroadbent]

Is RepCode numeric or a string?

Try <> &quot;999&quot; if a string or <> 999 if numeric. Terry Broadbent
Please review faq183-874.

&quot;The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge.&quot; - Daniel J Boorstin

 

[Danielle17]

It was a string...I used the Or statement and it worked. Thank you all!