Thank you. I am actually using reporting services

Thanks for your responses!

I got a solution and that was putting the date range parameter into a having clause and adding "Min(InvoiceDate) between...". That seems to have worked!...

Thank you.

some examples:

DECLARE @staff INT, @Start datetime, @End datetime

SELECT @staff = 183, @Start = '3/1/2010', @End = '2/28/2011'

cNumber ...

Basically, I am trying to get a list of the customers that have done work with us, where their FIRST ORDER was done within the specified date range.

I hope...

thanks! that worked!

Thank you!!!

By "helper table" do you mean creating a dbo table with 1 = 1st 2 = 2nd etc?

Thanks! I couldn't for the life of me figure out how to do that... I knew I was missing some kind of tie in.

You're the best, thanks again....

Thank you, I apologize for being vague and appreciate your response.

The intended goal was to have Five columns of data that would include the month, the costs and fees...

You're right, I hadn't considered that consequence.

Thank you.

Thank you Gail, my apologies.

Is there a way to delete a post that was placed incorrectly? I tried to find one, but couldn't.

~iklektic

Thanks again, I was able to accomplish it by placing the CASE statement into the query itself.

SELECT COUNT(DISTINCT AllWorkOrderItemReportView.WorkOrderID) AS TotalOrders,

...

Thank you @bt. Your help is greatly appreciated!

I was able to incorporate your query into my report.

~ iklektic

Alright, I apologize. I should have incorporated the code... was in a hurry and didn't have it in front of me... but here it is:

SELECT ...

There is a calendar that I use frequently. However, some reports I use are based on an entire months and I was trying to find a way to get the...