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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Limit on complex SQL statements

Status
Not open for further replies.
jpmillr1

jpmillr1

Technical User
Jun 13, 2003
12
0
0
US
Is there a limit to the complexity of SQL statements? I successfully wrote a query based on 6 combo boxes, and it worked once or twice. But then it stopped working and an error box said it was too complex. What gives?

Thanks,
John
 
Sort by date Sort by votes
There's no formal definition (as far as I know) on when a query becomes too complex based on the amount of combo boxes it uses! If you paste the SQL behind the query there's a chance that somebody here can re-write it for you so that it works...
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Swi
  • Locked
  • Question
Jet Sql Statement - Select Distinct Multiple Columns 1
Replies
4
Views
126
Swi
Swi
eerich
  • Locked
  • Question
IIF Help on complex query
Replies
5
Views
78
Andrzejek
Andrzejek
btamsgn
  • Locked
  • Question
How to arrange the values in column heading based on column STT
Replies
10
Views
277
combo
combo
Wolfdzn
  • Locked
  • Question
Join two seperate SQL into one
Replies
6
Views
79
dhookom
dhookom
supportsvc
  • Locked
  • Question
How to limit the number of records based on the quantity in a field? 1
Replies
8
Views
115
supportsvc
supportsvc

Part and Inventory Search

Sponsor

Back
Top