Think I might have solved this by leaving the field as an 'int' and set 'identity', 'identity seed', and 'identity increment'.

I hope that this works and will solve my issue.

Thanks Bill, I appreciate the time you spent in typing that up for me. I only wish books were written in the way that you guys write things on here....

Hi JeffB

I made a small change to the middle because I was still getting the error, however the change resolved this. Thanks for you help, really bailed me out of...

Hi JeffB

Thank you for taking the time you did to show this to me. Would I (case when.....) this within the existing Select statement so I could avoid writing other...

In addition to my previous post, would I be better to evaluate these conditions using a CASE statment in a second,third and fourth function and then deliver the results to...

Thanks for that. I looked it up in my Transact-SQL book and it gave me an idea how I can do it. Thanks for the direction to go in

Regards

Thank you for that. I will look at the settings for the date, you are right with your second point too. There are some zero's in the mix. I shall...

if that is your suggestion then that is the re-write I shall do. Thanks for pointing me in the right direction.

Thank you for your help, much appreciated

Regards,

This is getting on my nerves now. Here is the full monty and for the life of me I can not understand why it will not work.

Function 1:-

set

Thank you, I will give that a run. I appreciate you looking at this for me.

Regards

It is the actual layout that I am referring to.

Regards

Hey, no problem. Thanks for trying anyway

Regards

OK, you have kind of lost me there a little. The report I have is imported from Access and I have not seen the traditional grid etc that I got...

I have resolved this by using the following code as my query as suggested by someone else

Select site_ref, site_ref + ' - ' + estate_name AS Label

From dbo.src_centre_list

Order By site_ref

This...

Thanks, that solved my issue nicely.

Regards