Unspecified field

R

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query shows all the records of the tables without even selection 4
Can't create a report from my query in Access 1
Error: Specified field could refer to more than one table 8
Function of colon between table names when query in design view 4
How do you remove a Group By from a query? 2
Queries, see new fields when table design has changed 2
Query result shows all fields 1
extra field for a table as Text from table qry ? 5

Top