question on narrowing a query or report by one field

S

SteveP

I have a query that pulls 6 columns out of a table. These columns are:
Record #, Date Issued, Part #, Qty Rejected, Comments, DMR Complete. In the
table, the DMR Complete field is a text field with either 1(yes) or 0(no). I
am wanting to have a report that only shows the records that are not
closed...or 0 in that field. How and where (in the query or report) do I do
this? Any help is greatly appreciated.
 
K

KARL DEWEY

Open your query in design view and in the grid row named Criteria under DMR
Complete enter the numerial 0 (zero).
 
D

Douglas J. Steele

Assuming you're in the graphical query builder, put 0 in the Criteria row
under the DMR Complete field.
 
Top