>>>Hi
>>>
>>>My code is
>>>
>>>SELECT created,docket_no,pieces,weight,delivery,bagno,bar,aname,manidate FROM driver where;
>>> driver.aname = driversum.aname into table c:\global\driverpt
>>> select driverpt
>>>
>>>(at this point driverpt contains 1 record)
>>>
>>>report FORM "c:\global\driver.frx" TO PRINTER noconsole
>>>
>>>driver.frx only contains fields relating to driverpt
>>>
>>>but I get the same record printed 14 times - the same number as there are records in driver
>>>
>>>Can anyone shed any light on this?
>>>
>>>Thanks
>>>
>>>Colin
>>
>>Colin
>>
>
>Yes I select the table that I have just created - the DE contains that table name
>>Have you a table in the DE, and the fields' properties names including a table (not just the field)?
>>
>>Is your cursor the one selected just before you call the report?
>>
>>Terry

Sorry - my rely was in the wrong place - I forgot to add that fields contain the table as well as the field name