Append Query

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

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

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
 
A

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Appending a table by adding only records who are not duplicates 2
Access Macro Repeat Expression using value of a field in table 0
Not seeing expected results of append query 3
Append Query Issue 0
Avoiding duplication in a table. 2
Schedule Auto run Query on append table 0
Auto Populated a Table From SQL View When New Record Shows in View 3
Make Table v. Append to Table: Need Some Expert Design Inputs 7

Top