>Borislav:
>
>In the EXE the Table is empty, but in the IDE i got 10 values. That was the original problem. Why the EXE is not getting the values. If the values does not exist why Im getting the report that is from the same Database different view. my only guess is the variables MDate1 and Mdate2 are changing datatype for one process are Date type and for the other are string. But if that the problem in the IDE I should get an error.

Just add messageboxes for your mDate1/mDate2 and also please do BROWSE right after requery.