I now have this ...

SELECT #tblHolidays.HolidayDescription As [Description], #tblHolidays.HolidayDate AS [Holiday Date],

count(case #tblDepartmentHolidays.DepartmentID when 0 then 1 else null end) as [Global],

count(case #tblDepartmentHolidays.DepartmentID when 1 then 1 else null...

Thanks for all your replies. I am trying to write a cross tab query to return the data in the way I need it.

In the meantime, taking into account the...

Thanks for your reply.

I'm calling a Com Object to send the emails.

Thanks for your replies. What I am actually doing is gettign a list of people and then looping through that list passing an ID to another prodecure which might return...

Hi, thanks for your reply.

I get a syntax error though ...

Incorrect syntax near the keyword 'FOR'.

... but can't work out what I am doing wrong.

Cheers.