Max Wanadoo
max.wanadoo at gmail.com
Thu May 8 10:21:41 CDT 2008
You are one clever guy, Gustav. Any code? Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Thursday, May 08, 2008 4:17 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Make query design view look like data view Hi John Loop through the fields of the query and - for each field - set the ordinal position of the field to the index of the field? /gustav >>> jwcolby at colbyconsulting.com 08-05-2008 17:01 >>> When you view data in a query you can move the fields around, slide this field left, then this field right etc. If you SAVE the query after that, then the fields when viewing data are in a different order than the fields when viewing it in design. When it is a big query (lots of fields) it is very confusing trying to find a specific field in design view when it "should be" next to this field (as seen in the data view). John W. Colby www.ColbyConsulting.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com