Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query too complex in a Report

Status
Not open for further replies.
darude

darude

Programmer
Jun 23, 2003
138
US
Hi All,
Has anyone ever received an error "Query too complex" while running a report. I have a report that contains subreports and a lot of calculations. When I take out the next to the last entire line the report runs. When I put it back I get query too complex and there is nothing complex about the calculations. Any help would be much appreciated.

 
Sort by date Sort by votes
Could you paste that "complex" line, so we see, what the error might be?

RGDS,
MakeItSo

Andreas Galambos
EDP / Technical Support Specialist
Bowne Global Solutions Wuppertal, Germany
(andreas.galambos@bowneglobal.de)
HP:
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

SamuelR
  • Locked
  • Question
Dlookup in a report
Replies
13
Views
644
dhookom
dhookom
JimStrand
  • Locked
  • Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
555
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Print multiple copies of report data 1
Replies
5
Views
529
dhookom
dhookom
monkeysee
  • Locked
  • Question
Muti Page Report 1
Replies
5
Views
503
dhookom
dhookom
renigar
  • Locked
  • Question
Access 365 Report use nickname if exist instead of 1st name
Replies
4
Views
3K
renigar
renigar

Part and Inventory Search

Sponsor

Back
Top