[AccessD] Sequence number in query

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Mon Jan 23 19:21:25 CST 2006


Charlotte:

I just tried it - put the function into a module, put Expr1: qcntr(0) in 
the QBE of a query but the function only gets called once so each 
retrieved record has the same value - Cntr.  I was hoping for a sequence 
number.  Am I doing this wrong or is that the way it's supposed to work. 

Rocky


Charlotte Foust wrote:
> 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




More information about the AccessD mailing list