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 and another is Date (in the format [MM/DD/YYYY HH:MM:SS AM/PM]).
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, and for data from today's date (starting at 12:00). For example, Joe may get FileName ranges from 1001.html to 1100.html, Sue may get 1101.html to 1200.html, and so on.
I assume this would be accomplished with a simple update query. Is this the way to go and if so, what is the query?
Thanks,
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 and another is Date (in the format [MM/DD/YYYY HH:MM:SS AM/PM]).
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, and for data from today's date (starting at 12:00). For example, Joe may get FileName ranges from 1001.html to 1100.html, Sue may get 1101.html to 1200.html, and so on.
I assume this would be accomplished with a simple update query. Is this the way to go and if so, what is the query?
Thanks,
BFP