<div>
what would be the harm in simply taking the returned files as the new data set. &nbsp;Rather than just looking for the updated records, and then using that to update your own data set?<br />
<br />
If you have confidence that the returned files will be accurate, then just make some comparisons to ensure no records have gone missing, and once happy, overwrite the entire table?
</div>


what would be the harm in simply taking the returned files as the new data set.  Rather than just looking for the updated records, and then using that to update your own data set?

If you have confidence that the returned files will be accurate, then just make some comparisons to ensure no records have gone missing, and once happy, overwrite the entire table?

<div>
You could add a boolean field to the table(s) and simply check 'em afterupdate. <br />
Scott C
</div>


You could add a boolean field to the table(s) and simply check 'em afterupdate.
Scott C

<div>
what do you mean boolean field? will that help me find who updated any records?
</div>


what do you mean boolean field? will that help me find who updated any records?

<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
I have a data for 50 departments. Each department has 100 or more staff members. I have to send each deparmtne the data and they may make changes to it. I want to be able when &nbsp;I get the data back to filter out what was not changed and keep the one witth the changes, <br />
<br />
What would be the best way to do this. I can use excel or access. <br />
<br />

</div>
</div>


Hi All,

I have a data for 50 departments. Each department has 100 or more staff members. I have to send each deparmtne the data and they may make changes to it. I want to be able when  I get the data back to filter out what was not changed and keep the one witth the changes, 

What would be the best way to do this. I can use excel or access. 



Data

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.