Many thanks for the help below is what worked for me

SELECT *, dbo.tPeriod.PeriodDiscription, dbo.[tTimeTable2012-13].StaffID, dbo.[tTimeTable2012-13].DayID

FROM dbo.tSubject

INNER JOIN dbo.[tTimeTable2012-13] ON dbo.tSubject.SubjectID = dbo.[tTimeTable2012-13].SubjectID

AND (dbo.[tTimeTable2012-13].StaffID = 18) AND (dbo.[tTimeTable2012-13].DayID =...

Works like a dream.

Thank you so much

JB

Thank you all for helping me find a solution to this problem.

Stefan you solution gives me the desired results I need.

Many Thanks

Jay B

Hi Hope thie helps

tTimeTable

DayID PeriodID StaffID

1 1 ...

Hi

Maybe I'm going about this the wrong way.

I need to have the following recorded in a table or tables and the using my front end which is currently asp.Net show...

Hi

Thank you for getting back to me this is how i would get the Actual values one select for each date range but all the same.

SELECT ...

Hi

Thank you for your help and direction I sorted this out in Crystal Reports.

Cheers

Hi

Will have a play with two sp's and see what I can do not sure that it will work.

The results are being display in Crystal

Cheers for all you help

Hi

Thankyou for your help so far.

I need to see both records so if a saleID has 2 sites and 2 completion dates then i need to see both sites.

So in...

HI

But I need the site showing and the completion date.

I am not to good with Group By as you can see.

Cheers

Hi

Thank you for your post but i still get the same problem. two RefundedAmounts this is because they are the same SaleID (I think).

After I have done my Select could...

Hi

Sorry if i didnt make myself clear. below is the sp

ALTER PROCEDURE dbo.spCommissionsBydate

(@FromDate smalldatetime,

@ToDate smalldatetime)

AS SELECT dbo.tContacts.Surname, MIN(dbo.tSale.DateSold) AS DateSold, SUM(dbo.tSaleDetails.PlotPrice) AS PlotPrice,

dbo.tSaleDetails.CompletionDate AS [Comp date], dbo.tSalesPerson.SalesPerson, MIN(dbo.tCommissions.Percentage)...