Error: "Query too complex"

Heron

New member
Local time
Today, 01:56
Joined
Feb 4, 2002
Messages
8
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.
 

Users who are viewing this thread

Back
Top Bottom