View Full Version : Error: "Query too complex"


Heron
02-04-2002, 04:21 AM
Im using a series of expressions containing IIF statements to carry forward (itinerate) balances. I get this message and sometimes "System resource exceeded". I'm not using nested queries nor, do I think, too many fields. Access Specifications don't mention any such limitation. Im using Access 2000 on Win98 and a fairly fast comp. with plenty of memory.