[AccessD] Sequence number in query

Charlotte Foust cfoust at infostatsystems.com
Mon Jan 23 17:01:33 CST 2006


Take a look at http://support.microsoft.com/?id=94397  "Adding Dynamic
Counter to Query Count Records"

Charlotte


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
- Beach Access Software
Sent: Monday, January 23, 2006 2:12 PM
To: Access Developers discussion and problem solving
Subject: Re: [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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list