Ok, i try to give you as much informition as you need. The Tables are much greater, i post only a part:

Table Incident:

-ID

-date_logged

-Text

Table Problem:

-ID

-date_logged

-Text

But Incident and Problem are Different tables.

The...

Ola!

Tnx 4 your help but we dint find a solution. Thats why i try to specify my Problem. With

Select count(date_logged) as Inci_count, datename(month,date_logged) as Inci_Month

FROM incident

WHERE

date_logged > '20090101' AND date_logged...

Ola!

I modify your SQL Statement

Select count(date_logged) as M_Count, Month(date_logged) as M_Month

FROM incident

WHERE

date_logged > '20090101' AND date_logged < dateadd(mm, +2, '20090101')

group by month(date_logged)

But now i get a table like this:

M_Count...

Ola!

Tnx for yout Links. I read them and tried may way to get a report as i want. I found a solution but i think it is a worse workaround:

1)...