[AccessD] "Query is too complex"

I have run into the query too complex error several times.  I have gotten
around it by making a series of 2 to 3 queries, breaking up the complexity
some.  If I can I prefer to see if I can simplify the query though.
Multiple queries are a performance hit and harder to maintain.

Debbie

-----Original Message-----
From: Julie Reardon-Taylor [mailto:prosoft6 at hotmail.com]
Sent: Monday, July 28, 2003 2:54 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] "Query is too complex"



Hi Everyone,

Working in the 2002 version of Access.  Have a fairly large query that is 
giving me problems.  We keep getting an error message that tells me the 
"Query is too complex".  It worked a few days ago, until we added fourteen 
more fields and now we are getting the error.  Anyone run into this before?

Also, would like to purchase the developers edition of MS-Access 2002.  Do I

have to purchase the entire Office Developer's edition?  Is it a good idea 
to do so?

Thank you for any assistance you may be able to provide.


Julie Reardon-Taylor
PRO-SOFT OF NY, INC.
www.pro-soft.net

_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


- JENKENS & GILCHRIST E-MAIL NOTICE - This transmission may be: (1) subject
to the Attorney-Client Privilege, (2) an attorney work product, or (3)
strictly confidential. If you are not the intended recipient of this
message, you may not disclose, print, copy or disseminate this information.
If you have received this in error, please reply and notify the sender
(only) and delete the message. Unauthorized interception of this e-mail is a
violation of federal criminal law.

  This communication does not reflect an intention by the sender or the
sender's client or principal to conduct a transaction or make any agreement
by electronic means.  Nothing contained in this message or in any attachment
shall satisfy the requirements for a writing, and nothing contained herein
shall constitute a contract or electronic signature under the Electronic
Signatures in Global and National Commerce Act, any version of the Uniform
Electronic Transactions Act or any other statute governing electronic
transactions.