Hello,
can I write a query that will give percentages of records That has several criteria.
First criteria all the work orders must have PMINS,PMRT.PMOR ,PMREG,PMPDM.
Second criteria workorder must have a status of COMP.
Third criteria the target startdate must be between 8/19/18 and 8/25/18
Labor hours can not ==00:00
the actual start date must be between 8/19/18 and 8/25/18
divide that number with other sum of criteria
worktype i the same as above
status <> CAN
Target start date between two dates .
i need to run this query for each department and put the data in a unbound form that is a dashboard.
Any ideas.
can I write a query that will give percentages of records That has several criteria.
First criteria all the work orders must have PMINS,PMRT.PMOR ,PMREG,PMPDM.
Second criteria workorder must have a status of COMP.
Third criteria the target startdate must be between 8/19/18 and 8/25/18
Labor hours can not ==00:00
the actual start date must be between 8/19/18 and 8/25/18
divide that number with other sum of criteria
worktype i the same as above
status <> CAN
Target start date between two dates .
i need to run this query for each department and put the data in a unbound form that is a dashboard.
Any ideas.