My query has an exclamation next to it.

[popster]

I made a query in Access 2002, When I open Access and go to queries there is an Exclamation next to it. When I click it I get the message; "Query must have at least one destination field." I'm a beginner at this and have no idea what this means, can anyone help.
Thanks

 

[LarryDeLaruelle]

Popster:

The exclamation sign indicates that it is an action query (Make Table, Append, Delete).

The message indicates that you have not put any fields into the query grid. Open it in design view and and the fields you want in the output. Larry De Laruelle
ldelaruelle@familychildrenscenter.org

 

[danvlas]

It's a make table query. You can call it successfully 'make trouble query'. My personal opinion is that such type of queries must be avoided in the lagest extent possible

You only included the source table, without saying what fields you want the new table to have.

Daniel Vlas
Systems Consultant
danvlas@yahoo.com

 

[MichaelRed]

Danvlas,

Care to expand / expound on you personal phobia?

My personal opinion is that such type of queries must be avoided in the lagest extent possible


MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[danvlas]

Yes, Michael.
In a multi-user environment, a make-table query can be really tricky. Get some data, place it into a table and you have a static recordset. Requery, refresh, whatever you do, it's the same. To get fresh data, you have to run the query again-delete old table, create new table-unnecessary time consuming. Database size grows. Needs compacting more often. Have a query returning two different AutoNumber fields? Enjoy the error!
And...the most important side-effect: You run a make table query. Get your data and rely on it. Bobby - next door neighbour, runs the query for himself immediately after. By the time you open your form/report or whatever, your data has already been replaced.
It happened to me once, so I always search for another way to get my data. It is not always possible, I admit. But in most cases, it is.
"Hasn't happened yet" is not the same as "It will never happen"
I wouldn't call it 'phobia', as it doesn't frighten me.
Maybe paranoia would be closer...

Cheers

Daniel Vlas
Systems Consultant
danvlas@yahoo.com