Nov 13 2006, 05:04 PM
I have a query sourced by two tables and a query - when I remove the query from my design view, all fields using that table as a source go away, which is what I would expect.
When I try to run the query, I get the message
The Microsoft Jet database does not recognize 'MyQueryName.MyTableName.MyFieldName' as a valid field name or expression.
I go into the SQL view and there is no reference to the query or underlying tables - where is this coming from ?
Nov 13 2006, 05:26 PM
Try copying the sql into a new query and running it. Sometimes goofy things can happen with query dependencies which can be cleared up this way.
Nov 14 2006, 11:35 AM
I think I tried that, but will try again - in my experience, the "baggage" mysteriously goes with it to the new query
thanks for your input...
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here