Checkboxes and Reports

D

digger27

I am using Access to track jobs my company is doing out in the field. For
each job there are a set number of actions that need to be performed. When a
field associate checks the job he fills out a checksheet and this data is
transferredt to the database. Often there are things that are not checked
off and need follow up. I would like to create a report that shows all of
the relevent job info (address, contact, etc) and ONLY the actions that were
NOT checked off for each job. This way we only see the outstanding
activities that we need to fix. Any suggestions on how to accomplish this?
 
D

DanClayton

Create a new query combining all the fields you want in the report. If you
want data from two or more tables, the tables must be related.

The 'checked' info should be tracked via yes/no fields. Set the criteria in
the query for 'no' and create a report based on that query.
 
D

digger27

This actually doesn't give me what I'm looking for.
Here's a short example of what I need. I have the following fields to track:
Job#
Customer
Address
Job Item1, Job Item2, etc.
Job Items are checked off as they are completed.

I want a query or report that will show me for each Job# only the Job Items
that are not checked. If I do as below, and set "No" as the criteria, I will
only get back records that have all of these items unchecked, because this
works like an "AND" statement, saying Job Item1 AND Job Item2 AND.... = "No".
 
Top