var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Weekly Totals
I've searched for an answer to this question and could not find it.
I have a table with a date field and a unique identifier field. I am trying to figure out how many records we have in this table, PER WEEK. Simple.
Problem is, I can't figure out how to get that to happen in a query. Ideally I'd have results that looked like this:
week 1: 23
week 2: 100
week 3: 75.
Or something like this:
Can this be done in one query?
I'm not a techie, but I would love to find out how this could happen in one or two queries. Can someone offer a suggestion?
Many thanks to the person who answers this question.
select datepart(ww,datefield) as week
, count(*) as rows
Wow, that is great. Thank you. That is just what I wanted. I have so much to learn!