469,266 Members | 2,061 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,266 developers. It's quick & easy.

Destination Field?

JamesDC
66
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?
Mar 22 '07 #1
7 25224
JamesDC
66
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.
Mar 22 '07 #2
ADezii
8,800 Expert 8TB
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.
Mar 22 '07 #3
JamesDC
66
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
Mar 22 '07 #4
webcat
13
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
Nov 8 '07 #5
ADezii
8,800 Expert 8TB
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?
Nov 8 '07 #6
yinda
1
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
Nov 30 '07 #7
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
Oct 24 '08 #8

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Hank | last post: by
43 posts views Thread by Frodo Baggins | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.