Hi,
This query does everything I need except one thing and I am reaching out to expert out there for help. Thanks in advance.
SELECT DISTINCT Data.date_prescribed, (SELECT Count(*) FROM [Data] WHERE [Data].edi="T" OR [Data].printed="3") AS TotalPres,
(SELECT Count(*) FROM [Data] WHERE (([Data].edi="T" OR [Data].printed="3") AND [Controlled Substance] = "No")) AS TotalNonContPresc,
(SELECT Count(*) FROM [Data] WHERE [Data].printed="3") AS [Total Printed] INTO Report
FROM Data;
Result
Query2
date_prescribed TotalPres TotalNonCont PrescTotal Printed
1/13/2016 420 370 16
1/14/2016 420 370 16
1/15/2016 420 370 16
1/16/2016 420 370 16
1/17/2016 420 370 16
the total is the same of all days. how can I fix this?
This query does everything I need except one thing and I am reaching out to expert out there for help. Thanks in advance.
SELECT DISTINCT Data.date_prescribed, (SELECT Count(*) FROM [Data] WHERE [Data].edi="T" OR [Data].printed="3") AS TotalPres,
(SELECT Count(*) FROM [Data] WHERE (([Data].edi="T" OR [Data].printed="3") AND [Controlled Substance] = "No")) AS TotalNonContPresc,
(SELECT Count(*) FROM [Data] WHERE [Data].printed="3") AS [Total Printed] INTO Report
FROM Data;
Result
Query2
date_prescribed TotalPres TotalNonCont PrescTotal Printed
1/13/2016 420 370 16
1/14/2016 420 370 16
1/15/2016 420 370 16
1/16/2016 420 370 16
1/17/2016 420 370 16
the total is the same of all days. how can I fix this?