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!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Expression to complex error
As a side not I've found in Jet 4.0 there seems to be a max of 99 AND clasuses. This seems to be the root of my problem. I'm using some large text fields with many hard returns. Does anyone know of a way around this?- jlechem
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Expression to complex error
OK I'm working a vb.net application using OleDB connections to a ms access database. I'm running an update query on a memo style column and keep getting this expression to complex error. I've discovered it's due to the & clauses I believe. The query below causes the error but if I remove one...- jlechem
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
