Unspecified field

[Ron]

I deleted a field from a table and have been slowly
deleting it from all the queries that included it.

Usually I can just hit Design View and go in and delete
the field. BUT, I have one query that refuses to let me
open it in Design view. Whenever I try to open it in
design view I get the following:

"The specified field 'tbl_PaymentLog.DailyInterest' could
refer to more than one table listed in the FROM clause of
your SQL statement."

What the Hell is it talking about?! Is this another
freaky Access 2002 bug that wasn't in 2000? There IS NO
TABLE with a DailyInterest field. All I want to do is
delete it, but all it gives me is a bunch of SQL garbage.

Suggestions?

Thanks!

 

[Joan Wild]

Please post the 'SQL garbage'.