Thank you so much for the replies.

Both have resolved what I was trying to do 🙂

Thanks a million

J

Hello,

Thank you to both Mark and NULL for your great replies.

Both sets of code do exactly what they should do 🙂

Cheers

Julian

Hiya Mark

Thanks, this works a real treat on my 2005 database.

However, a database for another entity within the Company is a SQL Server 2000 database - I only just found...

Hello Jack,

Yeah - there sure is a lot going on in the query 🙂

The way the data is structured in the database means that to go from the first 3...

Hello Jack,

Yes, please find attached the query.

Since I created the original post, I have also discovered that if I uncomment the HAVING clause and comment out the call to the...

Hi

A couple of thoughts

1. Can you get an ODBC connection to your PROGRESS database from any other application e.g. Excel

2. Have you tried using the MERANT Progress ODBC driver

Kind Regards

J