John, wouldn't that just give an exact copy of the table, but with an extra field, "REC"?
>How about this.
>
>sele *,recno() as rec from table order by rec
>
>>Does anyone know the correct syntax to create a SQL VIEW and order it in record # order ? I tried to add "order by recno()" to the end of my create sql view definition but it returned an error SQL: Column ' ' is not found.
>>
>>Thanks For Your Help !
>>
>>Stephen J. Hunt
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.