Charlotte Foust
cfoust at infostatsystems.com
Mon Jan 23 17:01:33 CST 2006
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