Destination Field

[redheadfsa]

In Access 2010 what is the destination field? I keep getting 'query must have at least 1 destination field' when I try to fun it.

 

[jdraw]

Destination is equivalent to output

You must identify the fields you wish to see/output.

Can you show us the SQL of the query?

Go to design view, select sql view, copy the code and paste it in a message.

 

[redheadfsa]

Thank you so much for answering! :banghead: I found another such query that was actually working, so I deleted the one that was making me crazy. I tried to find it but it's not in my Recycle Bin, either. Here is the whopping code from the one that works. What is the destination field in this one?

SELECT Events.KeyWord, Events.Date, Events.Event, Events.Notes
FROM Events
WHERE (((Events.KeyWord)="Pet"));

:banghead:

 

[gemma-the-husky]

Answer: the three fields you have "selected"

do you do visual queries? if so, if you select table(s) but don't select fields for the display panel beneath, you will get the message you are describing.

or it may be to do with an update query - if you don't actually select a field to be updated.