This will get you the order count, grouped by Order Type, in date range shown.
It queries the Consolidate OE View table, so you get open and invoiced orders.
SELECT COUNT(ord_no) AS ord_count, ord_type
FROM OEINQORD_SQL
WHERE (ord_dt >= 20120101) AND (ord_dt <= 20120531)
GROUP...
thread639-1322726
The following Exact suggestion provided a fix for the error referenced in the above mentioned thread.
Run the MacSQL\Install\VBA6.3\vba6.msi installation manually
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.