Find records - multiple fields

C

Cowboy

I have a ProdPlan table that contains – amongst other – 8 text fields
(Process1 – Process8) and 8 Check box fields (Logic1 – Logic8) to track jobs
in production. I have created a Report (based on a Query) that hides the
process(es) when the relevant check box(es) is checked (i.e. completed
processes are hidden – but the job number/title still show). Jobs may use
various numbers of processes (i.e. some text field may be blank). QUESTION: I
only want the jobs (i.e. records) to show on the Report if a relevant process
that has been captured has not yet been checked – indicating work in
progress. Otherwise, if all processes are checked, the job number/title
should not be included in the report. What would be the best way?
 
K

KARL DEWEY

What about using a union query to normalizing your data?
SELECT Process1 AS Process
FROM ProdPlan
WHERE Logic1 = 0
UNION ALL SELECT Process2 AS Process
FROM ProdPlan
WHERE Logic2 = 0
.....
SELECT Process8 AS Process
FROM ProdPlan
WHERE Logic8 = 0;
 
D

Dale Fye

The way I read your post, a process is only "relevant" if it contains some
text in the associated Process field, and you only want to see those that are
"relevant" and which are not checked. If that is correct, you will need to
expand the WHERE clauses that Karl mentioned to include the Process fields.
something like:

WHERE Logic1 = 0 AND Len([Process1] & "") > 0
 

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

Top