Sergey

Have worked out what you meant - yes it gives me everything I need now - I will run it again tomorrow

Thanks for your help

Colin

>DBF()
>
>>
>>Can you tell me exactly how to do that - and in particular to make sure I get the full path of the alias
>>
>>Thanks
>>
>>>Add field to report with expression ALIAS() to see what the current alias is.
>>>
>>>>Yes I know but I deliberately selected the file vfp sql has just created but I will double check tomorrow
>>>>
>>>>Thanks Sergey
>>>>
>>>>>A report is driven by the alias that is current when report is launched. Do you have a timer or form with grid that could switch work area on you?
>>>>>
>>>>>>Yes driverpt and if I open the report and print it manually I get the right answer
>>>>>>
>>>>>>Thanks Sergey
>>>>>>
>>>>>>
>>>>>>
>>>>>>>It looks like wrong work area is selected when report is run. Do you have anything in reports DE?
>>>>>>>
>>>>>>>>