Count per date

[Danny]

Greetings,

I am trying to find out how many CODE that start with 772 exist for a given day.

In my query I used CODE Like “772*” which gives me part of what I want.
What I’m looking for is the number of CODEs per a given Date.

Please see the attached sample and let me know if you have any questions.

TIA

Regards,

 

[CJ_London]

use an aggregate query

group by date
count code
where code like 772*

something like

SELECT Date, Count(code) as CountofCode
FROM myTable
WHERE Code like '772*'
GROUP BY Date

 

[Danny]

CJ_London,

Thanks for your solution. It worked nicely!

Regards,