How to make Criteria in a Yes/No Field

[reive]

sori didn't read first the guidelines. i am using Access 2003.
Farmers - text data type
Planting Information - Yes/No data type
Harvesting Information - Yes/No data type
In the query, how can i make a criteria on a yes/no data type?so that the outcome will be the farmers name and only those which has a check mark signifying that they want this kind of brochure.it can not include the other field names which doesn't have a check mark.


note: planting information and harvesting are brochures to be given to the farmer if they want information regarding for example planting or harvesting procedure.
thanks

julie

[vijaydiwakar]

sori didn't read first the guidelines. i am using Access 2003.
Farmers - text data type
Planting Information - Yes/No data type
Harvesting Information - Yes/No data type
In the query, how can i make a criteria on a yes/no data type?so that the outcome will be the farmers name and only those which has a check mark signifying that they want this kind of brochure.it can not include the other field names which doesn't have a check mark.


note: planting information and harvesting are brochures to be given to the farmer if they want information regarding for example planting or harvesting procedure.
thanks

julie

julie, u have to use true or false keyword as
select * from table where <fieldname>=true

[MMcCarthy]

Julie is this what you are looking for ...

SELECT Farmers
FROM TableName
WHERE [Planting Information] = True;

SELECT Farmers
FROM TableName
WHERE [Harvesting Information] = True;

[NeoPa]

I hate to be contradictory (I love it really :D), but you should very rarely, if ever, compare a boolean result with either TRUE or FALSE. The most reliable (and recommended) way to check boolean values is simply by using them as booleans.

SELECT Farmers
FROM TableName
WHERE [Planting Information];

SELECT Farmers
FROM TableName
WHERE [Harvesting Information];

Anyone ever tells you different - send them to me :D