How many per month qry 1

[Spikemannen]

Hallo,

I have a tbl like this:

arrend
date
amount of time

And I would like my query to show how many arrends I have per month. How should I do this?

Best Regardz,

Spikemannen

 

[PHV]

Something like this ?
SELECT Format([date field], 'yyyy-mm') As [Month], Count(*) As [Count]
FROM yourTable
GROUP BY Format([date field], 'yyyy-mm');

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Spikemannen]

Okay... Thanks, but I do need som more input.
This is how it looks.

qryArrendsPerMonth

Arrende Date Amount of time
tblSupport tblSupport tblSupport

Where should put in you text?


Best Regardz,

Spikemannen

 

[PHV]

Go in SQL view and paste this code:
SELECT Format(tblSupport.Date, 'yyyy-mm') As [Month], Count(*) As [Count]
FROM tblSupport
GROUP BY Format(tblSupport.Date, 'yyyy-mm');

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Spikemannen]

Thank you very much

Best Regardz,

Spikemannen