update query

[Feprincess]

I clicked on update query and now I cannot open my query or my report.
Don't ask why I did it, stupidity??
Now when I try to open the query I get, "the query must have one destination field"
would someone help me get of this or am I stuck with it.
thanks

 

[CraigDolphin]

Right click on the query in your database window, then select the 'design view' option. The query design should open. Then either change it back to a select query (Query>Select Query) or else add the fields to the grid and macth them up to the appropriate field in the target table.

 

[Feprincess]

thank you.

ok, I've already opened it in design and changed it back to select query, but the query is empty?

 

[CraigDolphin]

Then you need to rebuild it....if you change a query to an update query without specifying the fields in the target table, and save it, then the 'irrelevant fields' will not be kept.