[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