>SQLEXEC ("select * from DATA", "cTemp")
>thisform.grid1.recordsource = "cTemp"

Not being an SQL regular, would:

SQLEXEC("select *, 0 as order from DATA", "cTemp")

do the trick? Then populate Order manually when you get it back?