Query to complex?

  • Thread starter Thread starter Geneve
  • Start date Start date
G

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
 
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.
 
Back
Top