Even better, select to a cursor and it goes away when the form is closed. That way there are never conflicts with othe users, and you don't have to worry about deleting the tmp tables.

>Thanks for the help. I'll just select to a table with a random filename, clear the values that I don't want, and run the report on that.
>
>Thanks,
>Chris
>
>>I cheat! I run my query to a read/write cursor with a field for the subtotal you want, then update that field using a SELECT DISTINCT.... or other means. Since you're working only with the report cursor this step is usually very fast.
>>
>>When the report prints, it prints the subtotal like it prints every other field with the header information - just once. If I need final totals, I will sometimes make a separate 'totals' cursor, index it and relate it to the original.
>>
>>HTH
>>Barbara
>>
>>>First a little explanation, then the problem:
>>>
>>>Lets say you have a report that prints invoices (some header information, followed by one or more detail lines).
>>>
>...
>>>
>>>VFP 6.0, using the VFP report writer.
>>>
>>>Thanks,
>>>Chris Vesper
>>>softdev@yahoo.com