[AccessD] Sequence number in query

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


Works!  (Of course, you knew that).  Curiously, it starts numbering at 
2.  If I change

   Cntr = Cntr + 1
   QCntr = Cntr

to
   QCntr = Cntr
   Cntr = Cntr + 1

it starts numbering at 1.

But...whatever works...

Thanks again.

Rocky


Charlotte Foust wrote:
> No, you put Qcnt([myField]) in the query and base it on a field that
> changes between records, like the PK.  You need to call SetToZero before
> you run the query or you'll get an ongoing sequence of numbers.
>
> 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: Monday, January 23, 2006 5:21 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Sequence number in query
>
>
> 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