I havve a grid on a pageframe. The recordsource type is SQL. The recordsource is:

"select Partno, Desc, QRec, QSold from Inven where Partno = thisform.currpart into cursor temp"

This works great as I navigate through the partno's.

If I change the recordsource to:

"select Partno, Desc, (QRec - QSold) from Inven where Partno = thisform.currpart into cursor temp"

I only get a single row in the grid for the first partno.

Is there a restriction I don't know about?

TIA- Swen