[AccessD] Sequence number in query

Charlotte Foust cfoust at infostatsystems.com
Mon Jan 23 19:38:20 CST 2006


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

-- 
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