OK moving on............The user either wants to select Orders by date range or simply return all Orders.

="TOTAL FOR MONTH:" & MONTH(First(Fields!Date.Value, "dsBidReport"))

Should display as December & not 12.

I have tried...

OK there is a flaw in my formatting! If I group every column then add to the group footer:

=MONTH(First(Fields!Date.Value, "dsBidReport")) & " " & Sum(Fields!Value.Value, "dsBidReport")

The Value 12 + Sum...

Thanks for the link. The table is being used for migration purposes so once the data is migrated to the new system it will no longer be required.

I worked on...

Thanks for the reply. I will haved a crack at the code tomorrow and post back if I hit a wall (table structure etc..)..

One quick question. As this is a...

Thanks Jack, pretty sure it wasn't but been wrong before 🙂

Thanks,

Phil.

Back again. I am sure I am missing a trick having reviewed the last error posted so do not waste any time on this thread, I will revisit what I...

Hi Lynn. I tried that initially which returned error:

Msg 8115, Level 16, State 2, Line 1

Arithmetic overflow error converting expression to data type datetime.

The statement has been terminated.

I then came...

Thanks Gail.

Thanks Ronald. I was having a blonde moment.

Initially I tried:

WHERE Products.ProductId LIKE 'DME_'

The returned zero.

Many Thanks,

Phil.

Thanks guys.

Phil.

I did not purchase the SQL Agent for Symanatec.

Phil.

Thanks for the replies. I keep 2 weeks worth as storage is not an issue at the moment.

Thanks,

Phil.

Chris many thanks, exactly what I was after.

Many Thanks,

Phil.

Thanks Chris. You were correct.

I ran the following after confirming your code executed OK:

INSERT INTO [Training].[dbo].[ProductProductCategories]

([Product])

SELECT p.Product

FROM [Training].[dbo].[Products] p

LEFT...

Thanks for the advice.

Phil.