EXPRESSION IN A QUERY

  • Thread starter Thread starter Peter Schweiss
  • Start date Start date
P

Peter Schweiss

Hello,
I need help to write an expression in my query. Here is
the criteria...
The field Is-Returned correctly..
There are 2 possible entrys for this feild, Yes or No...
I want this expression to Pick out the ones that are NO.

If anyone can help please email.
If you need more information regaurding the Expression
please email me.

Thank You,
Peter
 
Field: [Is-Returned]
Criteria: False

That should work if the field is a Yes/No field.
 
Hello,
I need help to write an expression in my query. Here is
the criteria...
The field Is-Returned correctly..
There are 2 possible entrys for this feild, Yes or No...
I want this expression to Pick out the ones that are NO.
Click to expand...

Two possible answers: if it is a Text field containing the text
strings "Yes" or "No", then put

"No"

on the criteria line.

If it is a Yes/No field, then put either

False

or

0 <the number zero>

on the criteria line.
If anyone can help please email.
Click to expand...

Done... though this request is considered impolite. Ask in the
newsgroup - come back to the newsgroup for the answer; private EMail
support is for paying customers.
 
Back
Top