Query to complex?

[Geneve]

Every time I try to run a particular query, I get a pop-up
message that says "Query is too complex" and it doesn't do
anything. I've had relatively simple calculations just
adding four columns together, and I still get the same
answer. I saw an earlier post that said something about
null values - Does it cause this problem if any of the
column values are zero? Are there other parameters that
make a query too complex to calculate? For instance, are
we limited to four or five variables? I've got to do some
pretty complex calculations to analyze data, and I'm
worried that Access won't be able to handle it (whereas
Excel can, but has other limitations). Please help!

Thanks!!
geneve

 

[Heather]

I've also encountered the same issue. Any information
would be greatly appreciated.

 

[geneve]

I searched earlier messages and found an answer. It
wouldn't let me forward the email to you, but look at
Sept. 8 at 10:21AM for the answer. It has the same title
in the subject line.