many Thanks for the advice on Ref Tables exclusions.

very helpful

thanks

many thanks

hi,

I've had a look, where exactly is the properties you are refering to. i have looked at both the parameter and the sub parameter dataset properties. i cannot see...

Thank you, I'll give it a go and let you know how i get on.

Thanks again.

Thanks for your reply.

i was unaware of the "WHERE NOT....." aspect avaiable and will give it a go.

Let you know how i get on.

thanks

many thanks

The only form of sequence we have is that the file comes correctly sorted.

We know that the rows are in the right order when we open the file.

????

I supppose we could add in a self gentrating row ID as we go along.???

This will eventually be imported from a csv/txt file via the import wizard in SQL...

Thanks Lowell, your snippets will be bery helpful in the future.

Cheers

Thank you both so much.

I say it after every sucessfull post, and I'll say it again...."I love the people on this site "

Cheers

Thanks Chaps, thats done the trick.

Love this site so much.

As long as you supply sample data and expected reults. (iI've learnt in the past :-))

Thanks again

Cool !!!

That the sort of thing i need as it going into a Business Intelligence system where users have to query aginst dates.

However, your dates come out as the 2nd...

Thanks, sorted the issue now.

many thanks, works a treat.

P

many thanks for all your helpfull suggestions.

P.