Nope. Interestingly, you can use a relative field number in an ORDER BY clause, but not in the SELECT clause. What is the business problem you're trying to solve? You could certainly generate the SQL in code using the TableDef and its Fields collection. John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/
_____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Clauss Gilbert Sent: Wednesday, June 28, 2006 2:23 PM To: [email protected] Subject: [ms_access] Field number in a query ? Is there a way, in a query, to use the field number instaed of its name ? Thank you ex : select field_nr_1, field_nr_2 from my_table [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> See what's inside the new Yahoo! Groups email. http://us.click.yahoo.com/2pRQfA/bOaOAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
