update data in table from query

[Guest]

I posted this question before but I probably relayed my question in a
confusing and convoluted manner. I have a table called tblTemp and a query
qryData. Whenever qryData is run I would like tblTemp to be updated with the
data returned from the query. Thanks.

 

[OfficeDev18 via AccessMonster.com]

Please copy and paste the query's SQL here.

Sam

I posted this question before but I probably relayed my question in a
confusing and convoluted manner. I have a table called tblTemp and a query
qryData. Whenever qryData is run I would like tblTemp to be updated with the
data returned from the query. Thanks.

 

[Guest]

SELECT qryConsolidate.[Open Date], qryConsolidate.CSR, qryConsolidate.TL,
qryConsolidate.[Ref# Number], qryConsolidate.[1st or 2nd Time],
qryConsolidate.[Who Failed to F/Up], qryConsolidate.[Which Region?],
qryConsolidate.[Dealer Name], qryConsolidate.[Handled By],
qryConsolidate.Status, qryConsolidate.[Resolution Provided],
qryConsolidate.Comments, qryConsolidate.[Root Cause], qryConsolidate.[Closed
Date], qryConsolidate.SumRow
FROM qryConsolidate
WHERE (((qryConsolidate.[Open Date]) Is Not Null));

Hope this helps.

 

[dot]

I posted this question before but I probably relayed my question in a
confusing and convoluted manner. I have a table called tblTemp and a query
qryData. Whenever qryData is run I would like tblTemp to be updated with the
data returned from the query. Thanks.

If qryData is a select query, you can change it to a maketable query
instead, with tblTemp as its output. Then the results would go into the
new table. If you need tblTemp to keep its old data, plus get the new
data, you would use an append query instead.

 

[OfficeDev18 via AccessMonster.com]

Certainly. Dot is correct!

Sam

If qryData is a select query, you can change it to a maketable query
instead, with tblTemp as its output. Then the results would go into the
new table. If you need tblTemp to keep its old data, plus get the new
data, you would use an append query instead.

 

[Duncan Bachen]

I posted this question before but I probably relayed my question in a
confusing and convoluted manner. I have a table called tblTemp and a query
qryData. Whenever qryData is run I would like tblTemp to be updated with the
data returned from the query. Thanks.

If qryData is a select query, you can change it to a maketable query
instead, with tblTemp as its output. Then the results would go into the
new table. If you need tblTemp to keep its old data, plus get the new
data, you would use an append query instead.