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