update table with Query results

[5166narda]

I need to update a history table with the results of a query that is run from input on a form in access. the query is tying a bunch of data together and giving me all the information I want. The problem is I am not sure on how to code in VB to access the results of the query. I can run the query --
stDocName = "qryrptall"
DoCmd.OpenQuery stDocName, acNormal, acEdit

but then how do I access the specific fields and load them into a table???

This is the query:
SELECT tblRptAll.Owner, tblHeader.Field1, tblHeader.Field2, tblRptAll.ExporterName, tblExporter.[Exporter Address1],tblExporter.[ExporterCity, State Zip], tblExporter.[ExporterTaxID Number], tblRptAll.StartDate, tblRptAll.EndDate, tblRptAll.ProducerName, tblVendors.ProducerStreetAddress1, tblVendors.ProducerCityStateZip,
tblVendors.ProducerTaxID, tblRptAll.ImporterName,
tblCustomers.CustomerAddress1,tblCustomers.CustomerCityStateZip, tblCustomers.CustomerTaxIDNumber, tblRptAll.Min,
tblproducts.ProductDescription, tblproducts.HSDescription,
tblproducts.HSTariffCode, tblproducts.PreferenceCriterion,
tblproducts.Producer, tblproducts.NetCost, tblproducts.CountryofOrigin, tblRptAll.Name, tblAuthor.Company, tblAuthor.Title, tblAuthor.Voice, tblAuthor.Fax, tblRptAll.CurDate, tblRptAll.Pages, tblRptAll.DocumentNo
FROM (((((tblRptAll INNER JOIN tblHeader ON tblRptAll.Owner = tblHeader.ID) INNER JOIN tblExporter ON tblRptAll.ExporterName = tblExporter.[Exporter Name])
INNER JOIN tblCustomers ON tblRptAll.ImporterName = tblCustomers.CustomerName) INNER JOIN tblproducts ON (tblRptAll.Owner = tblproducts.SelectHeader) AND
(tblRptAll.Min = tblproducts.MIN)) INNER JOIN tblAuthor ON tblRptAll.Name = tblAuthor.Name) INNER JOIN tblVendors ON tblRptAll.ProducerName = tblVendors.ProducerName;

The form provides all the tblrptall data.

Any help would be appreciated....

 

[Blorf]

Do you want to just add all of the results of your query into an existing table? Or are you updating records already there.

If just adding, then change the select to insert into, or use the query design form and select query type, append query and answer its questions.

Chaz

Ascii dumb question, get a dumb Ansi

 

[5166narda]

I am trying to add new records to an existing table. I tried creating an append query but it does not find any records when I run it??

 

[LNBruno]

Is doing a "DoCmd RunSQL" an option?

< M!ke >

 

[5166narda]

I tried that but then where does the results go?