Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

..."Query is too complex"-error message

Status
Not open for further replies.
glittle43

glittle43

Technical User
Jun 22, 2004
8
US
Can anyone give me some potentail causes of the error message..."Query is too complex"...thanks.
 
Sort by date Sort by votes
It might be too complex. Could you post your query's SQL view?

Duane
MS Access MVP
Find out how to get great answers faq219-2884.
 
Upvote 0 Downvote
I would have to say, that it's most likely because your query is "too complex" for access to handle...

refer to thread701-870076
 
Upvote 0 Downvote
You may want to try pasting the SQL statement into a new querydef. Sometimes Access gives this error message when the querydef has become corrupted.

Ed Metcalfe.

Please do not feed the trolls.....
 
Upvote 0 Downvote
Thanks for the feeback...I was forced to do multiple subqueries to slim it down. I am still not entirely sure why I get that error message. I appreciate everyone's input. Grant
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

mhshane
  • Question
Is this the best way to do this query? 1
Replies
9
Views
270
mhshane
mhshane
C
  • Locked
  • Question
Run-time error '3075': Syntax error (missing operator) in query expression 'Birthday = and Birthmonth ='.
Replies
3
Views
501
OzFoxy
OzFoxy
C
  • Locked
  • Question
Query expression negative to a 0
Replies
6
Views
581
dhookom
dhookom
serino
  • Locked
  • Question
Help with a Query. 1
Replies
13
Views
1K
strongm
strongm
combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
5K
combo
combo

Part and Inventory Search

Sponsor

Back
Top