[AccessD] Make query design view look like data view

John,
If you cut and paste the SQL from the SQL window of the query into a new
query I think it the feilds should frevert back to their original order?
Sorry can't test it at the moment
Rgds
Robin


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: 08 May 2008 16:01
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Make query design view look like data view


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


Dan Waters wrote:
> ???
> 
> They are already in the same order.  Need more info!
> 
> Dan
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Thursday, May 08, 2008 9:05 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Make query design view look like data view
> 
> Someone long ago published a method of making the design view of a 
> query
> look like the data view of the query, i.e. the fields in the same order 
> in design view as when you are viewing the data.
> 
> Does anyone remember this and can you publish it again?
> 
> Millones de Gracias!
> 
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com