[AccessD] Sequence number in query

Unfortunately, it's an aggregate query with no field I can use for the < 
factor.  But thanks anyway.

Rocky


William Hindman wrote:
> 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
>>
>>     
>
>
>   

-- 
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com