The report was created with fields from table1. In the report's dataenvironment there was only table2. At first, it did not occur to me to look in the data environment because it was a 2.6 report, which did not have dataenvironment. The tables were opened and selected in code. But somehow a dataenvironment got created and the incorrect table was in it.

Someone owes up a beer.

Thanks for both your help

Brenda


>Another good idea. :-)
>Let's wager a beer on who is right.

>>This problem really sounds like a trashed index to me.

>>>When this happens to me, it is usually because the report cursor or table is not the currently selected one when the report is run.

>>>>Have a statement "Report Form report1.frx to Printer". It prints the first record in the table for the correct number of records (recno). I have opened, selected and at the top of the correct table. Now when I "Report Form" only the first record shows on the report. If there are 10 records in the table, the first record shows up 10 times.
>>>>
>>>>The report1.frx was originally written in Foxpro 2.6 for windows. Is there a conversion that must be done.