Hi Lowell, thanks for the response. It doesn't appear to work. I get "SQL command not properly ended" error?

FYI

Select l.add, l.phne

from e_lkup l

where mins is null

GROUP BY phne,...

Eralper - a slight amendment to your code done the trick.

Many thanks for the responses guys.

Hi Nabha,

Thanks for the reply. Yes, your amendment is what I was looking for, it was obvious to me once I looked at your code.

I'll read up on the link...

Hi Andrew, Thanks for the update, I'll try it this way.

Cheers,

Laurence

Hi Guys,

I have managed to complete some of these changes, thanks for the assistance.

However, I have found that a few extensions do not exist on my database.

e.g....

Hi Guys,

Thanks for the responses. I give them a go and keep you posted with how I get on.

Thanks again.

Laurence

Hi GSquared,

Thanks for the response. I think you are right, just need to find that missing data now!

Can you advise how I would update if the towns where different values...

Hi GSquared,

Thanks for the quick response.

I get "(1 row(s) affected)" with that.

Any other suggestions? I can't seem to find anything online covering this.