Cheers Tom that's spot on!

And thanks to everyone else too!

I've been using this and it seems to partially work, it's returning people who have worked on 6 or more projects, but it's completely ignoring the date part of the...

The end date isn't important. The fact they're assigned to a project implies completion of the project.

The problem with that query is that it is counting every occurance of...

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[tblResources](

[ResourceID] [int] IDENTITY(1,1) NOT NULL,

[CompanyName] [varchar](50) NOT NULL,

CONSTRAINT [PK_Resource] PRIMARY KEY CLUSTERED

(

[ResourceID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE =...

Basically we need to perform audits on our recruiters every 6 months but it only applies to those who have worked on 6 or more projects in that time period....

If I was to run a query for the past 7 months - from today's date, I should find that ResourceID 1 - 'Research Opinions', has worked on 6 or...

Hope this helps:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[tblResources](

[ResourceID] [int] IDENTITY(1,1) NOT NULL,

[CompanyName] [varchar](50) NOT NULL,

CONSTRAINT [PK_Resource] PRIMARY KEY CLUSTERED

(

[ResourceID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE...

Thanks, that last one was spot on.