Queries possabiltys

[Freefaller]

I have a task to produce a query that can count the number of records that have a renewal date in a certain month (its a membership systeam).
Is this even possable? and if so how do format the queries?
I also have to find how many records have renewal dates in every month of the year does this mean seperate quires or is there some soprt cut?

 

[pbaldy]

Off the top of my head, try:

SELECT Month(RenewalDate), Count(*) As HowMany
FROM TableName
GROUP BY Month(RenewalDate)
ORDER BY Month(RenewalDate)

 

[Freefaller]

Thanks man ill give it a try and get back to you on it

 

[pbaldy]

No problem, and welcome to the site by the way.

 

[chundusmgs]

I have a task to produce a query that can count the number of records that have a renewal date in a certain month (its a membership systeam).
Is this even possable? and if so how do format the queries?
I also have to find how many records have renewal dates in every month of the year does this mean seperate quires or is there some soprt cut?

format renewaldate as below
FORMAT$([renewaldate],"mmm-yyyy")-enter this as expreesion and use group by option.

memberno exp1-as above

count groupby

i hope this will solve the problem