There is a problem i can't resolve and i hope i can get some help.

 

Intro:

I am using a SQL database with defirent type of calls. I wil call this table A, B and C. In these tables are information with the logged date (format: 01-01-2008 23:59:00)

 

Now i have to made a report with a overview with a mount of number of calls that is logged in a period. Period is equal to year.

 

I really have to use a formule, a cross-table is not possible. But now my question. How do i make a formula that is equal to this question:

 

if the logged date is equal to year 2008 then 1.

When I have this formula then i can make a distinct count in my report.

 

I hope there is someone who can help me.

(Excuse me for my poor english)

 

if table.logged date is between year(date('01-01-2008 23:59:00')) and year(date('31-12-2008 23:59:00'))

 

or something like that?

thanks for the help