How to select some not all column from a table then apend to another table?

M

Min

I have seen this function of Access run in Windows XP, but cannot find the
same or similar function of Access run in Windows 2000. Anyone can help?
Thanks!
Min
 
D

Douglas J. Steele

Create a query that has only the fields you want, and turn that into an
Append query (it's an option on the Query menu when you're in design mode)
 
M

Min

Thanks for your reply!

Douglas J. Steele said:
Create a query that has only the fields you want, and turn that into an
Append query (it's an option on the Query menu when you're in design mode)
Click to expand...
 
Top