I used the CopyFromRecordset Method and I found that this method didn't carry out with fields that they was came as a function result that I had created in Access module.
Note that the problem does not resist if the field is directly calculated and it is not from a stored function. According to this I could copy the body of my function directly in my Access qry as a calculated field but the function is too big and however I believe that it is not a good solution.
Is there any other way to solve this problem?
Thanks

Ok I have wrong...I take back my question,everything is Ok, sorry