I have found some negatives and have amended the query to check this. Presumabaly I need to do this for all the parameters passed to the substring?

OK, makes sense. thanks

Thanks!! Very silly from me. I have been staring at this thing for 40 mins.

Cheers

Thanks that seems to work. I tried something like that initially but kept on getting errors when parsing it.

Cheers

Many thanks for that, it seems to work. If i was to do it in sql 2k this would not be possible as CTEs cannot be used right? If this...

Many thanks for the information. It really helped. Apologies for asking obvious questions but I have been dealing with this report for a long time now and have taken care...

If I include the numeric month how will I be able to display aug-2009 for example?

I am aware of that but how can I specifically apply it for a parameter. That is to say where do I find the expression builder to format the parameter.

Many thanks. That exactly what I wanted to do. cheers

hey,

thanks for the info. I have had a good look on the internet and managed to find out the logic of what i was trying to do and managed...

I tried it with port 25 and then it seems to connect and prompts me to press any key to continue. When i press a key it says connection to...

OK i see. I have tried that and it said:

Could not open connection to the host, on port 587: Connect failed.

What does Telnet mean and how do i do that?

i have attached a copy of database configuration. From what I can see I have set it up correctly. I am just wondering if there is anything I need to...

Hi I have had a close look at the query and have founf that out of the 9 table scans many of them are not needed so i have...