Append Query

  • Thread starter Thread starter Frank Situmorang
  • Start date Start date
F

Frank Situmorang

Hello, I have Adcess2002, when I tried to make an append queiry, I do not see
in the wizzard neither in the ready desingn view, the way to make the append
query. Anyone can help us.
 
Create the select query.

In query design view, choose Append on the Query menu.
Access will ask which table you want to append to.
 
Thanks Allen for your explanation. Since the user normally, do not want to go
so many steps. Do you have the sample with VBA that guide user to do it with
menu?.

Thanks for your help
 
No. I never ask a user to create an append query, Frank.

What I tend to do is create a form where the user can enter the values (or
criteria or whatever) for the query, and then create the SQL statement in
code and Execute it.
 
Back
Top