Please enable JavaScript.
Coggle requires JavaScript to display documents.
SHIPMENT STATUS subform in DASHBOARD (quality conformed import…
SHIPMENT STATUS
subform in DASHBOARD
quality conformed import
QCconformedquantity
[QUERY]
idproduct[tblproduct] groupby
CONFORMED: Sum([Form Responses 1]![تعداد پالت منطبق]*[tblProducts]![PALLcapacity]) EXP
dat: Val([Form Responses 1]![تاریخ و زمان تایید نهایی]) ASC groupby
MainPrime[QUERY]
part [main] groupby
plan [main] sum
Date [main] groupby
Done [main] sum
Conformed
[QCconformedquantity [QUERY]] sum
shipmentSTATUS[QUERY]
shipment status[ FORM]
done: SumOfDone [MAINPRIME] SUM
conformed
: SumOfCONFORMED [MAINPRIME] SUM
plan: SumOfPlan [MAINPRIME] SUM
Fulfilled
: IIf([plan]=0;"NA";Round([done]/[plan];2)*100) & "%" EXP
INDEX [tblproducts] groupby
WHERE DATE[MAINPRIME] >=13970325 And <=13970330
VEHICLE [tblproducts] groupby
WHERE PLINE[TBLPRODUCTS] = "WS"
Ready
: IIf([plan]=0;"NA";Round([conformed]/[plan];2)*100) & "%" exp
Not Sent
: IIf([done]>[conformed];"OK";[conformed]-[done]) exp
Form Responses 1
dashboardloader
(stdt As Variant, fidt As Variant, lne As Variant)
update shipmentstatus form
select case me.line [WS,BL,SL]
Me.shipmentstatus.Form.RecordSource = strsql
strsql from shipment status query with change date and line conditions
needed tbl and qry
form responses 1
QCconformedquantity **[QUERY]
MainPrime[QUERY]
shipment v1.14
BSGv2.7.5 uc