I have been messing around with groups and I cant get it to work, I only have a very basic table and it only has 1 group inside of it,...

very true, so If I have two input dates, how do I find the disinct number of months?

I did try this approach, but found that I couldnt get the Expressions...

Thanks for the Reply Mark,

I agree that my SQL has to change I suppose, I wil let you know how it goes and how I solved it.

Cheers!

It might do, Ill have a go in a little while and let you know.

Exactly! which was the problem, so I found that the joins were the issue here, and I needed to re-think the way my query was to work.

Well maybe I can go about doing this another way, the issue here is that when a user passes a comman seperated list of subject id's to my SP, i...

Will that Exists function slow down the query at all?

I mean, in terms of the performance of that function in comparison to a join.

Also it seems that when I...

Thanks for the replies guys, I was hoping it wouldnt be so difficult. I will try to find a way around the issue I think, rather than do something messy...

Currntly in my setup for my own apps that Ive have (somewhat) written myself. I have all the code looking onto views directly. Not to tables (or as you mentioned...

Yeah I see what you are saying, but even views, just plain old views that just select all columns in a certain table I have read to be 'better' than...

Thats what I thought, but I have read post where people live by the fact that they never look onto tables directly, even the most basic 2 column tables.

if you take out the drill down can you still see them? Be sure to check the visibility properties on each row in the table

Steve, I see what your saying now, I dont know what I was thinking. It works just fine in RS. The SQL i showed you was not dynamic, just pure...

Thanks for the reply, but like I said, none of the status' have an id of 99, so nothing gets returned

does it give you an error code? If so, search google for it, sometimes you can get great specific help on it