question on narrowing a query or report by one field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Open your query in design view and in the grid row named Criteria under DMR
Complete enter the numerial 0 (zero).
 
Assuming you're in the graphical query builder, put 0 in the Criteria row
under the DMR Complete field.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dynamic calculated field in query 3
Access Dcount (multiple criteria) 3
Narrowing query results 16
Have both records from two queries/tables under one Query without related fields. 0
Can't create a report from my query in Access 1
Access Access Report Works on One Machine but not Another 3
Make table query: [Enter 1] AS Test 1
Populating null field in queries 8

Back
Top