ms access - combining two SQL SELECT COUNT(*) statements - Stack Overflow

You can get both counts as two values in a single row using the following SQL statement: SELECT ( SELECT Count(*) AS OrderCount FROM ( SELECT DISTINCT OrderNo FROM tblDisposition ) ) AS OrderCount ...

stackoverflow.com