[AccessD] Make query design view look like data view

Aaaargh!  After ten years of Access I had no idea this could be done. Maybe
that's called being focused; maybe not!

Thanks!
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Thursday, May 08, 2008 10:01 AM
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