Destination Field?

[JamesDC]

Hey all,

I'm having a big problem right now...

I'm using Access 2002 with my Database.

The program was running fine yesterday, and I went to use it today and found that all my Reports would come up blank. SO I checked my queries and I get this error:

Query Must Have At Least One Destination Field.

I don't know what this means, or why it happened. Can somebody please shed some light on this?

Thanks,

James

EDIT: Opening the queries in Design view shows that the Queries have no fields anymore :( what has caused this? Is it fixable?

[JamesDC]

Alright, I freaked out :S

I copied the SQL from the blank query from a backup and now it's running again.

I'd just like to know why the query could suddenly go blank like that? Does this happen often or maybe somebody intentionally did it... which I doubt.

[ADezii]

Hey all,

I'm having a big problem right now...

I'm using Access 2002 with my Database.

The program was running fine yesterday, and I went to use it today and found that all my Reports would come up blank. SO I checked my queries and I get this error:

Query Must Have At Least One Destination Field.

I don't know what this means, or why it happened. Can somebody please shed some light on this?

Thanks,

James

EDIT: Opening the queries in Design view shows that the Queries have no fields anymore :( what has caused this? Is it fixable?

Query Must Have At Least One Destination Field typically occurs whenever there are no Fields in the QBE Grid. Queries do not typically go blank on their own. You must have inadvertantly deleted the SQL Statement while in SQL View.

[JamesDC]

That's the thing I never opened the query. My database is set up that you can't get access to the back matter (DB, querries, etc.) without doing a certain procedure. I was just in the front section, the forms which allow one to open the reports...

oh well it's fixed now, it was just scary

[webcat]

i have this same issue where my query is deleted.

very interested to know why and if there was ever a solution...

it happens over and over again, i have to keep a backup of all my SQL queries elsewhere and paste them back in! this is NOT good.. !

thanks

[ADezii]

Alright, I freaked out :S

I copied the SQL from the blank query from a backup and now it's running again.

I'd just like to know why the query could suddenly go blank like that? Does this happen often or maybe somebody intentionally did it... which I doubt.

Have you made any changes to the Tables which make up the Queries?

[yinda]

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

[strbrstgrl]

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