Update Query Help

[GBalcom]

Hello,
I have two tables, tblLog, and tblCalendarDump. They both have the following Fields: WorkOrderID, CalendarEventID, and CreateDateCalendar.


tblLog holds records that are to include information pulled by tblCalendarDump. They both have WorkOrderID fields populated, so I need to find the WorkOrder ID, then update the tblLog CalendarEventID, and CreateDateCalendar fields with the data that is in the tblCalendarDump table.

The tblCalendarDump is just to hold this data when I pull it in from an ODBC link. The reason I'm doing this is that the information on this record is coming from several sources....this is one of them.

Is this possible with an update query or am I opening two recordsets in VBA? looking for the quickest batch style solution.

 

[plog]

Possible with SQL, but most "batch solutions" require VBA. From the sounds of it the UPDATE query would be pretty simple--you haven't explained any rules of it, but so far it sounds like a straight update.

You also haven't explained the frequency or any dependencies this has when running. Nor any other processes you need to do. Explain more the events surrounding this--what else do you have to do to the data? When does it need to run--automatic or manually? Etc.

 

[GBalcom]

Plog,
This will be run by a VBA driven Event. I would just prefer a Query because I've been told they run faster than a recordset.

I've never used an update query in this manner before. That is, Each record that needs updating finding the correct information based upon the cooresponding record in the other table that has a matching Work order number....Is there a way to accomplish this with an Update Query?

I'll post this, and make up a quick PDF explaining more that I'll post in a minute.

 

[GBalcom]

See attached

 

[plog]

Here's a link to how UPDATE querie's work in Access:

https://support.office.com/en-us/ar...te-query-9dddc97c-f17d-43f4-a729-35e5ee1e0514

Make a copy of your database and then play with it.

 

[GBalcom]

oh jeesh

I was able to get it figured out...that really opens the door! I've relied so much on Recordsets, I've forgot what an update query is capable of....

Thanks again!