It's not the same behavior with functions... you must specify that you want the default parameter, like this :

Select * from dbo.Fn_myDate(default)

Can you run the profiler and see what query is ran when that happens?

Nothing... I thaught you still needed help.

Nice work.

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.