[AccessD] Sequence number in query

Charlotte:

I came up with no matches on qcntr search.  Do you get any hits on that 
search? I think I might have been thinking of running sum on a report. 

Rocky


Charlotte Foust wrote:
> Jim Dettman posted a trick several years ago.  Look up Qcntr in the
> archives.
>
> Charlotte Foust
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
> - Beach Access Software
> Sent: Saturday, January 21, 2006 2:18 PM
> To: Access Developers discussion and problem solving
> 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