Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

query must have at least one destination field?


(!)

bluebloods's Avatar
bluebloods bluebloods is offline
Member with 209 posts.
THREAD STARTER
 
Join Date: Oct 2004
Experience: Computer Illiterate
20-Mar-2005, 06:51 PM #1
Arrow query must have at least one destination field?
what is that supposed to mean?
im trying to make an append query but this message comes up
Ziggy1's Avatar
Computer Specs
Member with 2,525 posts.
 
Join Date: Jun 2002
Location: Ontario,Canada
Experience: Advanced
20-Mar-2005, 07:46 PM #2
You did not add fields to the query design grid, when you started to create the Append table you would have selected which table was going to be appended by the query. After that you need to add which fields are going to Append to that table. then if the query contains the same field names as the table it will automatically populate the "append to" otherwise you will need to use the dropdown to select the appropriate field.
Anne Troy's Avatar
Computer Specs
Member with 11,731 posts.
 
Join Date: Feb 1999
Location: Allentown, PA
Experience: Intermediate
20-Mar-2005, 09:38 PM #3
If you do not want to append (add records to) another table, then change the query type to (probably) "select".
joed202902's Avatar
joed202902 joed202902 is offline
Member with 80 posts.
 
Join Date: Mar 2005
Experience: Advanced
20-Mar-2005, 11:18 PM #4
bluebloods,

I highly recommend you make a copy of the table to which you want to append records....experiment with the copy 1st. Also, make sure you have selected the Append Query from the tool bar. Then yes, you must define at least one destination field which is where the data will go.
Anne Troy's Avatar
Computer Specs
Member with 11,731 posts.
 
Join Date: Feb 1999
Location: Allentown, PA
Experience: Intermediate
20-Mar-2005, 11:24 PM #5
Nice, joed. I often forget the cautions...
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑