too complex to be evaluated?

[Guest]

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

 

[Guest]

Try this --
SELECT [Q_Past Due Banking Curtailments Part 1].*
FROM [Q_Past Due Banking Curtailments Part 1]
WHERE ((([Q_Past Due Banking Curtailments Part 1].OnReport) = "Yes"));