[AccessD] Sequence number in query

http://ourworld.compuserve.com/homepages/attac-cg/AqryTip.htm#AUTONUM

William

----- Original Message ----- 
From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Saturday, January 21, 2006 5:17 PM
Subject: Re: [AccessD] Sequence number in query


> Jim:
>
> No, it was some clever trick in the QBE that would neatly number the
> rows retrieved by the query.  I think using -1 for something had
> something to do with it but I'm not sure.
>
> Rocky
>
>
> Jim Lawrence wrote:
>> Hi Rocky:
>>
>> You mean drop a place holder like this?
>>
>> SELECT "" AS AddedField1, "" AS AddedField2
>> FROM MyTable;
>>
>> HTH
>> Jim
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin -
>> Beach Access Software
>> Sent: January 21, 2006 9:32 AM
>> To: Access Developers discussion and problem solving
>> Subject: [AccessD] Sequence number in query
>>
>> Dear List:
>>
>> There is a trick to creating a column in a query with a sequence number
>> 1, 2, 3, 4... but I can't remember what it is.  Does anyone recall this?
>>
>> MTIA
>>
>>
>
> -- 
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.e-z-mrp.com
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>