Did you ever resolve your problem? I had the same problem and I finally figured it out. I was using basic SQL, and when I clicked 'design view' access couldn't represent the query. If that happens to you as well, you need to use the expression builder to represent the query in access language. I just double clicked 'criteria' in the query design window, and built the expression. For example, I originally had:
SELECT table1.field1
FROM table1 INNER JOIN table2 on table1.field1 LIKE table2.field1
This query would cause the error and become cleared, even though it worked. I used the expression builder to build the "LIKE" expression, and it turned out to be:
SELECT table1.field1
FROM table1 INNER JOIN table2 on table1.field1 = table2.field1
WHERE ((([table1]![field1] LIKE [table2]![field1])));
Just make sure your query can be represented in the query builder, and you shouldn't have any problems.
I'm having the same problems with my db's.
The db is running everyone morning for reporting. But everytime after the reports have run i have to paste my Backup DB over the db in the right folder so that it can run again the next day. If i don't do that the db will not run because there are query's in it that have no data in it. It gives the error Query must have at least one destination field.
I really need some help with this because this sucks bigtime. I have checked everywhere for a solution but just can't find anything.
kind regards
66
