Counting occurrences

[wrkinprogress]

Hello all, I have a question for you. I have a DB in SQL 2000 that I am accessing with SQL 2005 Reporting Services.

I have the report set up to display the records in the order that I want them, but I would like to add one more parameter. I would like to code in a way to return the results based on the number of times a person's username is in the DB.

The query results are already displayed within a date range, and I want to further filter them by only listing the ones that have >3 occurrences (username) within that date range.

Any help is greatly appreciated.

Thanks

[wrkinprogress]

Hmm, no one?

[unhitchedjet]

You can try this..

Select Username, X, X, Y from tblYYY Where Username in (
Select UserName From tblYYY Group by UserName Having Count(UserName) > 3) AND Date (Between date1 and date2);

[wrkinprogress]

Thanks

It still seems to want to grab even the records that just have one "instance" in the table.

[unhitchedjet]

Can you please post your actual query and the output.