There are two tables, one with a "master record", an initial set of records. The other is a table that is constantly updated through a VBA script that imports a .csv every 10 minutes.
What I want is the query to check every field in the import table and compare it to all records and fields in the master table. I then want it to append any changed fields to the master table for permanent record.
I have been fussing and fiddling with this for a week now, rebuilt this query in VBA, SQL and query design wizard. Unfortunately my knowledge in all of these is limited and I always bit a roadblock. Can anyone tell me what I am up against and point me in the right direction with an example of how they would do this. Thank you very much.
Why the start menu gets so much attention on windows is beyond me. It designed to make windows accessible to everyone , from a complete novice to a power user. Hooray if you use the start menu, and Hooray if you don't
It's iconic and a useful accessible place to see all your apps. That was its core goal, and it still delivers that today, in arguably a much simpler, easier to manage way than in years gone by.
I think the key thing to note is MacOS has the Launcher, a place where all apps are listed. Prior to that, a list of apps were only accessible via Finder Apps folder, and the dock was auto populated as apps were installed. With the upcoming MacOS 26? release it looks like Launcher is becoming more menu like, rather than full screen, which I think shows how useful such a feature actually is.
At the end of the day, the vast majority of users will rely on the Start Menu for accessing their apps. While there are many other ways to go about it, it's actually a very well designed, simple, yet feature rich menu (obviously with some issues) that make using a computer so damn simple. And that's why Microsoft needs it, because Windows isn't Linux.
Question
Michael Lacey
Hi,
I have a database that I need to run a query on.
There are two tables, one with a "master record", an initial set of records. The other is a table that is constantly updated through a VBA script that imports a .csv every 10 minutes.
What I want is the query to check every field in the import table and compare it to all records and fields in the master table. I then want it to append any changed fields to the master table for permanent record.
I have been fussing and fiddling with this for a week now, rebuilt this query in VBA, SQL and query design wizard. Unfortunately my knowledge in all of these is limited and I always bit a roadblock. Can anyone tell me what I am up against and point me in the right direction with an example of how they would do this. Thank you very much.
Link to comment
https://www.neowin.net/forum/topic/1253758-ms-access-question/Share on other sites
1 answer to this question
Recommended Posts