Append Query

[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.

 

[Allen Browne]

Create the select query.

In query design view, choose Append on the Query menu.
Access will ask which table you want to append to.

 

[Frank Situmorang]

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

 

[Allen Browne]

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.