query

[leaf]

Hello there,

I am creating a report to output a list of subjects from
my tables that are ineligible. I created a query to grab
the fields needed in the report. In a query under
Criteria in the ineligible field, I wrote "if
ineligible=yes". Ineligible is the field name from my
table. Is that the right syntax?

Many thanks,

leaf

 

[kevinrea]

you put too much actually..

all you need to put in the criteria under the field ineligible is

"yes"

you should include the double quotes...


i have included a screen shot for you...

kevin

File Attached: http://www.MSAccessForum.com.com/forums/attachment.php?postid=95361 (inexligible.jpg)

 

[John Vinson]

Hello there,

I am creating a report to output a list of subjects from
my tables that are ineligible. I created a query to grab
the fields needed in the report. In a query under
Criteria in the ineligible field, I wrote "if
ineligible=yes". Ineligible is the field name from my
table. Is that the right syntax?

No. The criterion should be just a value of the field; if it's a
Yes/No datatype just use

Yes

or equivalently, -1.

 

[Pavel Romashkin]

if "ineligible" is of Yes-No data type, simply use

SELECT..... WHERE Ineligible

Notice that you have to have a default value for it or make sure to use
Nz() to eliminate Null values from Ineligible.
Pavel