[AccessD] Sequence number in query

Rocky,
just go to this page and click on download.


http://www.microsoft.com/downloads/release.asp?releaseid=29437

Even though the sample database is in German it should be self-explanatory.

Helmut 







-----Ursprungliche Nachricht-----
Von: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]Im Auftrag von Rocky Smolin
- Beach Access Software
Gesendet: Samstag, 21. Januar 2006 23:18
An: Access Developers discussion and problem solving
Betreff: 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