[AccessD] Sequence number in query

Charlotte Foust cfoust at infostatsystems.com
Mon Jan 23 10:47:43 CST 2006


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