>Oh I like this myself!
>SELECT RECNO() AS myfield
>
>Is that what you mean Kia? That's an interesting approach I have never considered before.

Roxanne, check out some other recent threads on Recno() in SQL-Selects. It's only reliable when you are working with a single table.

Barbara