Hi All.
Our database is updated every night with new data. One of the columns in the main table that is updated nightly is called FileName. I would like to be able to automatically populate another column called Owner (Not part of data dump) based on the FileName, where Owners are assigned to file ranges. For example, Joe may get FileName ranges from 1001.html to 1100.html, Sue may get 1101.html to 1200.html, and so on.
It would seem to be that the best way to accomplish this would be to run an update query once for the initial pass, and then once each time the dB or main Form is opened on the new data.
So my questions are:
1) Is an update query the correct/best way to accomplish this task? (If so, what might it look like?)
2) How can a query (or whatever) be run on only newer data (rows) without affecting older data. The data dump does include a column called comment date in the form [MM/DD/YYYY HH:MM:SS AM/PM].
Thanks in Advanced,
BFP
Our database is updated every night with new data. One of the columns in the main table that is updated nightly is called FileName. I would like to be able to automatically populate another column called Owner (Not part of data dump) based on the FileName, where Owners are assigned to file ranges. For example, Joe may get FileName ranges from 1001.html to 1100.html, Sue may get 1101.html to 1200.html, and so on.
It would seem to be that the best way to accomplish this would be to run an update query once for the initial pass, and then once each time the dB or main Form is opened on the new data.
So my questions are:
1) Is an update query the correct/best way to accomplish this task? (If so, what might it look like?)
2) How can a query (or whatever) be run on only newer data (rows) without affecting older data. The data dump does include a column called comment date in the form [MM/DD/YYYY HH:MM:SS AM/PM].
Thanks in Advanced,
BFP
