[AccessD] Queries with a mind of their own

There is an option under Tools/Options/Tables Queries to "Output All Fields"

I wonder if this has been mistakenly checked?

Gary Kjos
garykjos at hotmail.com





>From: "Selina Iddon" <selina at easydatabases.com.au>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "Access Developers discussion and problem 
>solving"<accessd at databaseadvisors.com>
>Subject: [AccessD] Queries with a mind of their own
>Date: Wed, 7 Jan 2004 14:38:36 +1000
>
>Hi Everyone
>
>I've been away for quite a while, hope everyone had a Happy New Year.
>In the past day a couple of my databases have started going haywire.  I
>create a query, add the field I want but if I try and group then it gives 
>me
>the message you can group on "*" fields ... true, but I didn't add any and
>there are none showing in the design pane.  So I run the results pane
>without grouping and sure enough, the field I did add is there in front,
>then every other field of every table is there too.  I go into SQL view and
>sure enough there is an *, but I didn't do it, if I manually take this out
>it's then fine, but how did it get there in the first place.  This is
>happening with all new queries I'm making it would seem ... and when 
>editing
>some old ones.  Any ideas?
>
>Thanks
>
>Selina
>
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Get reliable dial-up Internet access now with our limited-time introductory 
offer.  http://join.msn.com/?page=dept/dialup