Microsoft Jet database error in report

[Guest]

Hi,

I am modifying an existing report that a former employee created (and is
thus unavailable to help) and am getting the error "The Microsoft Jet
database engine does not recognize 'ELD' as a valid field name or
expression." The problem is that field does not exist in any of the
supporting queries - and isn't supposed to - so I'm not certain what is
triggering the error. The supporting queries all run fine on their own.
I've verified that the report is using the new query and not the old one and
I've set criteria in the query to specifically exclude 'ELD' even though it
shouldn't be there anyway.

Any suggestions for what else can I try?

Thanks,
Dianne

 

[Brendan Reynolds]

Check the Filter and Order By properties of the report. Possibly the field
'ELD' might be referenced in one of those properties?