If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Find records - multiple fields
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? -- Cowboy |
#2
|
|||
|
|||
Find records - multiple fields
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; -- Build a little, test a little. "Cowboy" wrote: 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? -- Cowboy |
#3
|
|||
|
|||
Find records - multiple fields
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 ---- HTH Dale "KARL DEWEY" wrote: 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; -- Build a little, test a little. "Cowboy" wrote: 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? -- Cowboy |
Thread Tools | |
Display Modes | |
|
|