I'm trying a different route. The data for my Db consists of 1 table of employee data that will be updated weekly based on info sent from our HR office. I will import their data & overright the existing data (the table is used for to verify caller info for password resets - it's never edited/etc).
Is there VBA I could use to create an update or append query that will look at one field (county) & create the log in ID based on the county #? In other words, have an extra field called ID whose data is created by the query, & the format is taken from the code that says if the county = xx, then the ID field format is Lname-Fname, or something like that?
Also - since I want the weekly imported data to overwrite the existing data, what's the best way? Wipe out the data first?
Any & all ideas/suggestions would be appreciated!
Is there VBA I could use to create an update or append query that will look at one field (county) & create the log in ID based on the county #? In other words, have an extra field called ID whose data is created by the query, & the format is taken from the code that says if the county = xx, then the ID field format is Lname-Fname, or something like that?
Also - since I want the weekly imported data to overwrite the existing data, what's the best way? Wipe out the data first?
Any & all ideas/suggestions would be appreciated!
