S
Sarah
A report in my database has been working perfectly until today. No changes
have been made to the report or the queries it is based on, but I am now
getting a "too complex to be evaluated" message.
The SQL for the query tied to the report is:
SELECT [Q_Past Due Banking Curtailments Part 1].[Dealer Name], [Q_Past Due
Banking Curtailments Part 1].[Serial#], [Q_Past Due Banking Curtailments Part
1].Manufacturer, [Q_Past Due Banking Curtailments Part 1].Model, [Q_Past Due
Banking Curtailments Part 1].Year, [Q_Past Due Banking Curtailments Part
1].[Line Type], [Q_Past Due Banking Curtailments Part 1].LineCat, [Q_Past Due
Banking Curtailments Part 1].[Maturity Date], [Q_Past Due Banking
Curtailments Part 1].[Floored Date], [Q_Past Due Banking Curtailments Part
1].[Original $ Floored], [Q_Past Due Banking Curtailments Part 1].Expr,
[Q_Past Due Banking Curtailments Part 1].expr1, [Q_Past Due Banking
Curtailments Part 1].expr3, [Q_Past Due Banking Curtailments Part
1].DueinFull, [Q_Past Due Banking Curtailments Part 1].FlooredDtDaysPastDue,
[Q_Past Due Banking Curtailments Part 1].Outstanding, [Q_Past Due Banking
Curtailments Part 1].Curtailment, [Q_Past Due Banking Curtailments Part
1].MatMonthsPastDue, [Q_Past Due Banking Curtailments Part 1].OnReport,
[Q_Past Due Banking Curtailments Part 1].MonthsOnBooks, [Q_Past Due Banking
Curtailments Part 1].DaysOnBooks, [Q_Past Due Banking Curtailments Part
1].CurtDate
FROM [Q_Past Due Banking Curtailments Part 1]
WHERE ((([Q_Past Due Banking Curtailments Part 1].OnReport) Like "Yes"));
As you can see, all information in this query is being pulled directly from
the Part 1 query; the only field being qualified on is the OnReport field.
The Part 1 query works just fine, and if I remove the 'Like "Yes"' from the
Part 2 query, it works as well.
I have two other reports in my database that are structured in exactly the
same way, with a Part 1 and a Part 2 query, that also only show records with
an OnReport value of "Yes". These continue to work correctly.
I'm not sure what the cause of this error could be. Any suggestions?
Sarah
have been made to the report or the queries it is based on, but I am now
getting a "too complex to be evaluated" message.
The SQL for the query tied to the report is:
SELECT [Q_Past Due Banking Curtailments Part 1].[Dealer Name], [Q_Past Due
Banking Curtailments Part 1].[Serial#], [Q_Past Due Banking Curtailments Part
1].Manufacturer, [Q_Past Due Banking Curtailments Part 1].Model, [Q_Past Due
Banking Curtailments Part 1].Year, [Q_Past Due Banking Curtailments Part
1].[Line Type], [Q_Past Due Banking Curtailments Part 1].LineCat, [Q_Past Due
Banking Curtailments Part 1].[Maturity Date], [Q_Past Due Banking
Curtailments Part 1].[Floored Date], [Q_Past Due Banking Curtailments Part
1].[Original $ Floored], [Q_Past Due Banking Curtailments Part 1].Expr,
[Q_Past Due Banking Curtailments Part 1].expr1, [Q_Past Due Banking
Curtailments Part 1].expr3, [Q_Past Due Banking Curtailments Part
1].DueinFull, [Q_Past Due Banking Curtailments Part 1].FlooredDtDaysPastDue,
[Q_Past Due Banking Curtailments Part 1].Outstanding, [Q_Past Due Banking
Curtailments Part 1].Curtailment, [Q_Past Due Banking Curtailments Part
1].MatMonthsPastDue, [Q_Past Due Banking Curtailments Part 1].OnReport,
[Q_Past Due Banking Curtailments Part 1].MonthsOnBooks, [Q_Past Due Banking
Curtailments Part 1].DaysOnBooks, [Q_Past Due Banking Curtailments Part
1].CurtDate
FROM [Q_Past Due Banking Curtailments Part 1]
WHERE ((([Q_Past Due Banking Curtailments Part 1].OnReport) Like "Yes"));
As you can see, all information in this query is being pulled directly from
the Part 1 query; the only field being qualified on is the OnReport field.
The Part 1 query works just fine, and if I remove the 'Like "Yes"' from the
Part 2 query, it works as well.
I have two other reports in my database that are structured in exactly the
same way, with a Part 1 and a Part 2 query, that also only show records with
an OnReport value of "Yes". These continue to work correctly.
I'm not sure what the cause of this error could be. Any suggestions?
Sarah