Fill automatic a table with the data of a queery table

[Guest]

I have 2 tables. One table is a Queery table and the other is simple tample.

Querry table has these fields:

Name, ID, Lesson.

The simple table contain:

Name, ID, Lesson, Number.

Of course, the fields of the querriy table fill with data when i run the
Querriy. Now i want these data fill automatic the same fields of the simple
table.HOW CAN I DO THAT? I tried from look up wizard but the result was a
list box where i must select the name and ID, separataly. And i Want to open
the simple table and find the first three fields already filled with the data
from the Querriy table and I write only the data for the Number Field.I
believe that I must notice that I have made the connections between the equal
fields of the simple and querriy table from relationships.

 

[Steve Schapel]

Andreas,

There really isn't any such thing as a "query table", and it may help to
avoid confusion to not use this terminology.

If you go to the design view of your query, and make it into an Append
Query (select Append from the Query menu), you will be able to set it up
to put the records into the table. To make this happen, "run" the
append query... you can do this from the query design view by clicking
the toolbar button with the red ! icon.

 

[Guest]

Dear Steve,
During the night, i thaught that maybe i must change the type of the query,
and in the morning i use, withouth any succes of course, the update query.
So, I decide to connect to web and i see your answer. As I can see, it works.
Thanks! I have forgotten to use Append.

 

[onedaywhen]

There really isn't any such thing as a "query table"

Perhaps the OP is more familiar with Excel, which has a QueryTable
object:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/xlobjQueryTables.asp

it may help to
avoid confusion to not use this terminology.

I agree. Often the the Excel newsgroups I see posts using the term
'Access Query' when of course they mean a Jet VIEW or PROCEDURE.

Jamie.

--