Setting a condition to print only certain records

[kcmiuser]

I have created an application for creating work orders for the maintenance department. I have almost everything functioning the way I want except for one report. This report will show only open work orders, it is created from a query and has a field that is indicates if work order is completed by either yes or empty (no). For the life of me I cannot figure out the criteria needed to limit only printing open work orders (a condition of 'no'). I am just stuck for some reason and I know the answer is relatively easy. Any ideas will be most helpful.


Kcmiuser

[ranman256]

in the query , under the field for [COMPLETED] , put criteria : IS NULL

then only not completed will show.

[kcmiuser]

in the query , under the field for [COMPLETED] , put criteria : IS NULL

then only not completed will show.

Sorry I made an error on this request, I was looking at another report in this application. This situation has a condition of yes or no, not a null value. How do I filter for a condition of 'no'

[orange]

You may find this info from Martin Green useful.
http://www.fontstuff.com/access/acctut06.htm

[ranman256]

same advice, but instead of the NULL, put NO in the criteria.

[kcmiuser]

Perfect, thanks