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