So what's wrong with the final select statement you have??

Maybe you'd be able to create columns or the reports, and have 2 rows of 2 columns display.... should be easier than to tweak the select.

"XML is like violence...If it doesn't solve your problem, you are not using enough of it"

exactly .

Amit's trick will certainly help you someday. But what do you mean by customized sort? What do you need exactly?

Many things can cause this in access.

One of the most annoying thing I find in access is the urge to save every little value of each paramter of each control...

Could you post the ddl to create the tables and insert some data?

It'll be easier to give a better shot at it.

Can you send us the execution plan so that we may give more pointers?

I told you that I didn't test the query. It was just to give you an idea. I've never had to write anything like this and frankly, I'm not...

Doh!!! missed an easy one here

run this code, I think it reproduces the error exactly :

Sub x()

On Error GoTo Gestion

Dim MyRs As ADODB.Recordset

Set MyRs = New...

This may be an error that stops the code. DRI errors or other major errors like column name doesn't exists causes the code execution to end, never entering the...

np... this will surely help somebody in the future.

Thanx for the contribution.

Open a connection to the server, fetch the data and do whatever you have to do to it.

Check http://www.Connectionstrings.com

BTW I haven't found anything that is NOT possible to...

Can't answer this one... But it's not something I've been able to do with Access ADPS (sql server back end). I'll see what I can dig up tomorrow (pls...

This is not an actual column in the database, and therefore cannot be updated in the db.