>Is there any way to have SELECT selects RECNO()? TO make it harder I have more then one table in this SELECT statement.
>TIA Mark

You could try:

Select ..., Recno("Table1") as RecNo1, Recno("Table2") as RecNo2 ...

Something like:

Select table1.*, recno("Table1") as RecNo1, ...

would most likely not work. You have to explicitly list all the fields you want.