when i run my query an error message that says "query too complex

J

jam dorado

I make an accounting system with Access 2007. But when I run my Cash Flows
report which includes the Net Income from the Income Statement report an
error message that says "query too complex" appear. Anyone help me please.
 
J

Jon Lewis

Just a minute.......
Ummmmmmmmmmmmmmm
Yes I'm seeing your Cash Flows report!
Ummmmmmmmmmmmmmm
Yes I'm seeing the Income Statement!
Ummmmmmmmmmmmmmm
Yes I'm seeing the query! Ahhh there's the cause of the problem - can you
see it too?

My psychic powers are good today!

Seriously, you need to post alot more detail! :)
 
J

John W. Vinson

On Mon, 31 Mar 2008 23:58:01 -0700, jam dorado <jam
I make an accounting system with Access 2007. But when I run my Cash Flows
report which includes the Net Income from the Income Statement report an
error message that says "query too complex" appear. Anyone help me please.
Click to expand...

Simplify the query, or correct the error in the query.

If you would like help doing so, please open the query upon which the report
is based in SQL view and post it here.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Solved Disk Full error message when exporting PDF 0
Too Many Fields Defined Error 1
IRR function in Excel 2010 returns #NUM! error for an investment withall negative cash flows 9
Error on Access Query 10
SQL Query Too Complex 2
Access on Netbook 2
how to create a report that represents an income statement 1

Top