[AccessD] Sequence number in query

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Tue Jan 24 11:33:18 CST 2006


Mark:

Thanks.  Similar to the routine in the link Charlotte posted.  Guess 
that's the best way to do it.

Best,

Rocky


Mark A Matte wrote:
> Rocky,
>
> I can't remember where I got this...but I used it to generate a number 
> sequence in a query...the problem was displaying and scrolling through the 
> records...but it did work using an append query and saving the results.  I 
> did have to reset the counter after each time, but no big deal.  I just 
> called the foolowing function from my query:
>
> Option Compare Database
> Option Explicit
> Global lngTableCounter As Long
>
> Function MyAutoCtr(prmAny)
> 'Trick is to pass a field from the input table(s) so that function called 
> for each record
> 'otherwise Access thinks that the function will always return the same value 
> and
> 'only calls it once, and every output record gets the same value
> MyAutoCtr = lngTableCounter
> lngTableCounter = lngTableCounter + 1
> End Function
>
> Hope it helps...
>
> Mark A. Matte
>
>   
>> From: Rocky Smolin - Beach Access Software <bchacc at san.rr.com>
>> Reply-To: Access Developers discussion and problem 
>> solving<accessd at databaseadvisors.com>
>> To: Access Developers discussion and problem 
>> solving<accessd at databaseadvisors.com>
>> Subject: Re: [AccessD] Sequence number in query
>> Date: Tue, 24 Jan 2006 06:07:16 -0800
>>
>> Gustav:
>>
>> I'm trying to create a column for the x axis of a graph, so it's for a
>> report.  I think I may do what I usually do which is to whip up some
>> code to create a temp table rather than trying to make a query do tricks.
>>
>> I did use the Qcntr thing and it worked.   Now I've got to start
>> fiddling with the chart thingy to see if I can get it to behave.
>>
>> This is for a Preventive Maintenance application that I am developing in
>> partnership with a guy in Bangalore.  There's not a very big market for
>> the application but it's fun trying to do a joint venture at that
>> distance with someone you've never met.  I actually don't think that the
>> graph will be all that useful but it's part of his design so I'm going
>> to do it.  He knows the user's needs.
>>
>>
>> Rocky
>>
>>
>> Gustav Brock wrote:
>>     
>>> Hi Rocky
>>>
>>> It won't work for a select query you display and browse.
>>> Don't know it that is your case.
>>>
>>> How many records do you have?
>>> Did you try out "my" SQL only trick? Not invented by me and not very 
>>>       
>> fast but fast enough for small recordset and very reliable. And no reset 
>> code needed.
>>     
>>> /gustav
>>>
>>>
>>>
>>>       
>>>>>> bchacc at san.rr.com 24-01-2006 02:14 >>>
>>>>>>
>>>>>>             
>>> Aha!  Thank you.  I thought there was something one could do in the
>>> query like the running sum trick but a function with a global should do
>>> nicely.
>>>
>>> Thanks again
>>>
>>> Rocky
>>>
>>>
>>> Charlotte Foust wrote:
>>>
>>>       
>>>> Take a look at http://support.microsoft.com/?id=94397  "Adding Dynamic
>>>> Counter to Query Count Records"
>>>>
>>>> Charlotte
>>>>
>>>>         
>>>
>>>       
>> --
>> 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
>>     
>
>
>   

-- 
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com




More information about the AccessD mailing list