I think I have made some progress but it's still not working.

This is the code I have now.....

ALTER TRIGGER [dbo].[Update_jobsAggregate]
ON [dbo].[Jobs]
FOR...

Hi Sue,

If you have a jobs table that has a million records in it, a view that aggregates that table will have to load the million rows into...

@ J Livingston SQL

Thanks for your reply. It's ok, I have talked it over with the customer and I have been able to modify a report he already...

Thank you all very much for your time and replies.

I have asked the customer to mock up a report to show me exactly what they want and...

I have tried it with and without the quotes. Without the quotes it says invalid column name

Yes, orderdateandtime is a datetime field.

Yes,

This is how it looks now and I still get the same error.

SELECT
  dbo.Sales.SALESDESCRIPTION,
  dbo.Groups.GROUPDESCRIPTION,
  ...

Thank you Thomas.

In the actual query, it's in SSRS, I use variables for the dates so the < part of the query is the variable + 1...

Yes, I just noticed the OR, I have changed that to AND now but it still gives the same error

I think I may have answered this myself

Each text box that the address details are in, number them in order of the addresslines (textbox1, textbox2 etc...)

Put...

Thank you for your help