Sir I am seeking a help in Access.
I have got one Union query which gives an error 'This expression is typed incorrectly or too complex to be evaluated' is getting. But if the statement executes separately with out UNION clause it is generating correctly. Pls advise how to sort out the issue.
My query statement is as follows.
SELECT format([Query4.DATE],"dd/mm/yyyy") as dates, Query4.shift, Query4.machineno as mc,Query4.sd_sider as sider, Query4.count,round([Query4.prdnkgs],2) as prdnkgs,round(Query4.production,2) as hank,Query4.WKDSPINDLES as wspdl,round([query4.stdgps],2)as stdgps,round([query4.gpsach],2)as gpsach, round([query4.stdkg],2)as stdkg,round((stdgps*wspdl)/1000,2) as stdkgs,round(gpsach/stdgps*100,2) as pper,round(wspdl/query4.spindle * 100,2) as uper,round(pper/uper * 100,2) as eper,query4.waste,round(query4.waste/prdnkgs *100,2) as uwas,round(Query4.stpmnts,2) as stpmnts,query4.speed
FROM Query4
GROUP BY Query4.DATE, Query4.shift, Query4.machineno,Query4.sd_sider, Query4.count, Query4.production, Query4.CNO, Query4.SPINDLE, Query4.STPMNTS, Query4.WKDSPINDLES, Query4.prdnkgs,query4.stdgps,Query4.gpsach,Query4.stdkg,query4.speed,query4.waste
UNION SELECT q4.DATE , q4.shift, q4.machineno as mc,q4.sd_sider, q4.count, round([q4.prdnkgs],2) as prdnkgs,round(Q4.production,2) as hank,q4.WKDSPINDLES as wspdl,round([q4.stdgps],2) as stdgps,round([q4.gpsach],2) as gpsach,round([q4.stdkg],2) as stdkg,round((stdgps*wspdl)/1000,2) as stdkgs,round(gpsach/stdgps*100,2) as pper,round(wspdl/q4.spindle * 100,2) as uper,round(pper/uper * 100,2) as eper,q4.waste,round(q4.waste/prdnkgs *100,2) as uwas,round(q4.stpmnts,2) as stpmnts,q4.speed
FROM q4
GROUP BY q4.DATE, q4.shift, q4.machineno, q4.sd_sider,q4.count, q4.production, q4.CNO, q4.SPINDLE, q4.STPMNTS, q4.WKDSPINDLES, q4.prdnkgs, q4.waste,q4.stdgps,q4.gpsach,q4.stdkg,q4.speed;
SELECT format([Query4.DATE],"dd/mm/yyyy") as dates, Query4.shift, Query4.machineno as mc,Query4.sd_sider as sider, Query4.count,round([Query4.prdnkgs],2) as prdnkgs,round(Query4.production,2) as hank,Query4.WKDSPINDLES as wspdl,round([query4.stdgps],2)as stdgps,round([query4.gpsach],2)as gpsach, round([query4.stdkg],2)as stdkg,round((stdgps*wspdl)/1000,2) as stdkgs,round(gpsach/stdgps*100,2) as pper,round(wspdl/query4.spindle * 100,2) as uper,round(pper/uper * 100,2) as eper,query4.waste,round(query4.waste/prdnkgs *100,2) as uwas,round(Query4.stpmnts,2) as stpmnts,query4.speed
FROM Query4
GROUP BY Query4.DATE, Query4.shift, Query4.machineno,Query4.sd_sider, Query4.count, Query4.production, Query4.CNO, Query4.SPINDLE, Query4.STPMNTS, Query4.WKDSPINDLES, Query4.prdnkgs,query4.stdgps,Query4.gpsach,Query4.stdkg,query4.speed,query4.waste
UNION SELECT q4.DATE , q4.shift, q4.machineno as mc,q4.sd_sider, q4.count, round([q4.prdnkgs],2) as prdnkgs,round(Q4.production,2) as hank,q4.WKDSPINDLES as wspdl,round([q4.stdgps],2) as stdgps,round([q4.gpsach],2) as gpsach,round([q4.stdkg],2) as stdkg,round((stdgps*wspdl)/1000,2) as stdkgs,round(gpsach/stdgps*100,2) as pper,round(wspdl/q4.spindle * 100,2) as uper,round(pper/uper * 100,2) as eper,q4.waste,round(q4.waste/prdnkgs *100,2) as uwas,round(q4.stpmnts,2) as stpmnts,q4.speed
FROM q4
GROUP BY q4.DATE, q4.shift, q4.machineno, q4.sd_sider,q4.count, q4.production, q4.CNO, q4.SPINDLE, q4.STPMNTS, q4.WKDSPINDLES, q4.prdnkgs, q4.waste,q4.stdgps,q4.gpsach,q4.stdkg,q4.speed;
I have got one Union query which gives an error 'This expression is typed incorrectly or too complex to be evaluated' is getting. But if the statement executes separately with out UNION clause it is generating correctly. Pls advise how to sort out the issue.
My query statement is as follows.
SELECT format([Query4.DATE],"dd/mm/yyyy") as dates, Query4.shift, Query4.machineno as mc,Query4.sd_sider as sider, Query4.count,round([Query4.prdnkgs],2) as prdnkgs,round(Query4.production,2) as hank,Query4.WKDSPINDLES as wspdl,round([query4.stdgps],2)as stdgps,round([query4.gpsach],2)as gpsach, round([query4.stdkg],2)as stdkg,round((stdgps*wspdl)/1000,2) as stdkgs,round(gpsach/stdgps*100,2) as pper,round(wspdl/query4.spindle * 100,2) as uper,round(pper/uper * 100,2) as eper,query4.waste,round(query4.waste/prdnkgs *100,2) as uwas,round(Query4.stpmnts,2) as stpmnts,query4.speed
FROM Query4
GROUP BY Query4.DATE, Query4.shift, Query4.machineno,Query4.sd_sider, Query4.count, Query4.production, Query4.CNO, Query4.SPINDLE, Query4.STPMNTS, Query4.WKDSPINDLES, Query4.prdnkgs,query4.stdgps,Query4.gpsach,Query4.stdkg,query4.speed,query4.waste
UNION SELECT q4.DATE , q4.shift, q4.machineno as mc,q4.sd_sider, q4.count, round([q4.prdnkgs],2) as prdnkgs,round(Q4.production,2) as hank,q4.WKDSPINDLES as wspdl,round([q4.stdgps],2) as stdgps,round([q4.gpsach],2) as gpsach,round([q4.stdkg],2) as stdkg,round((stdgps*wspdl)/1000,2) as stdkgs,round(gpsach/stdgps*100,2) as pper,round(wspdl/q4.spindle * 100,2) as uper,round(pper/uper * 100,2) as eper,q4.waste,round(q4.waste/prdnkgs *100,2) as uwas,round(q4.stpmnts,2) as stpmnts,q4.speed
FROM q4
GROUP BY q4.DATE, q4.shift, q4.machineno, q4.sd_sider,q4.count, q4.production, q4.CNO, q4.SPINDLE, q4.STPMNTS, q4.WKDSPINDLES, q4.prdnkgs, q4.waste,q4.stdgps,q4.gpsach,q4.stdkg,q4.speed;
SELECT format([Query4.DATE],"dd/mm/yyyy") as dates, Query4.shift, Query4.machineno as mc,Query4.sd_sider as sider, Query4.count,round([Query4.prdnkgs],2) as prdnkgs,round(Query4.production,2) as hank,Query4.WKDSPINDLES as wspdl,round([query4.stdgps],2)as stdgps,round([query4.gpsach],2)as gpsach, round([query4.stdkg],2)as stdkg,round((stdgps*wspdl)/1000,2) as stdkgs,round(gpsach/stdgps*100,2) as pper,round(wspdl/query4.spindle * 100,2) as uper,round(pper/uper * 100,2) as eper,query4.waste,round(query4.waste/prdnkgs *100,2) as uwas,round(Query4.stpmnts,2) as stpmnts,query4.speed
FROM Query4
GROUP BY Query4.DATE, Query4.shift, Query4.machineno,Query4.sd_sider, Query4.count, Query4.production, Query4.CNO, Query4.SPINDLE, Query4.STPMNTS, Query4.WKDSPINDLES, Query4.prdnkgs,query4.stdgps,Query4.gpsach,Query4.stdkg,query4.speed,query4.waste
UNION SELECT q4.DATE , q4.shift, q4.machineno as mc,q4.sd_sider, q4.count, round([q4.prdnkgs],2) as prdnkgs,round(Q4.production,2) as hank,q4.WKDSPINDLES as wspdl,round([q4.stdgps],2) as stdgps,round([q4.gpsach],2) as gpsach,round([q4.stdkg],2) as stdkg,round((stdgps*wspdl)/1000,2) as stdkgs,round(gpsach/stdgps*100,2) as pper,round(wspdl/q4.spindle * 100,2) as uper,round(pper/uper * 100,2) as eper,q4.waste,round(q4.waste/prdnkgs *100,2) as uwas,round(q4.stpmnts,2) as stpmnts,q4.speed
FROM q4
GROUP BY q4.DATE, q4.shift, q4.machineno, q4.sd_sider,q4.count, q4.production, q4.CNO, q4.SPINDLE, q4.STPMNTS, q4.WKDSPINDLES, q4.prdnkgs, q4.waste,q4.stdgps,q4.gpsach,q4.stdkg,q4.speed;