<div>
how often are the data streams updated? Is it feasible to store the data in one table? That would be my preference. &nbsp;Otherwise, you can use a UNION query to combine the fields from multiple recordsets into one long list
</div>


how often are the data streams updated? Is it feasible to store the data in one table? That would be my preference.  Otherwise, you can use a UNION query to combine the fields from multiple recordsets into one long list

<div>
They are updated monthly.<br />
Thanks!<br />
Dennis
</div>


<div>
<div class="content wysiwyg-content">
I have two streams of data that ultimately feed the same activities. <br />
<br />
The tables are similar but different.<br />
There are fields in one that identify the original source of the data.<br />
<br />
My desired state would be for the system to treat this as a single set of data. Then query it to pull the results needed.<br />
<br />
Before I go too deep into this, I thought my expert friends may be able to provide some best practices used in similar scenarios.<br />
<br />
Thanks!<br />
Dennis
</div>
</div>


I have two streams of data that ultimately feed the same activities. 

The tables are similar but different.
There are fields in one that identify the original source of the data.

My desired state would be for the system to treat this as a single set of data. Then query it to pull the results needed.

Before I go too deep into this, I thought my expert friends may be able to provide some best practices used in similar scenarios.

Thanks!
Dennis

Access 2013 design question

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.