# Simple (?) MS Access / Database question
**URL:** https://boards.straightdope.com/t/simple-ms-access-database-question/184623
**Category:** Factual Questions
**Created:** [June 26, 2003, 9:06pm UTC](https://boards.straightdope.com/t/simple-ms-access-database-question/184623 "2003-06-26T21:06:47Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@rexnervous](https://boards.straightdope.com/u/rexnervous)
#### Post date: [June 26, 2003, 9:06pm UTC](https://boards.straightdope.com/t/simple-ms-access-database-question/184623/1 "2003-06-26T21:06:47Z")
I have two tables of data from different sources. I want to create a new table that takes data from TableA and TableB only if a certain field in both tables match.
I’ve tried various queries but I’m a noob at Access (maybe this can be done in Excel, instead?). Can anyone help?
Thanks in advance.
---
### Author:  [@drachillix](https://boards.straightdope.com/u/drachillix)
#### Post date: [June 26, 2003, 9:42pm UTC](https://boards.straightdope.com/t/simple-ms-access-database-question/184623/2 "2003-06-26T21:42:55Z")
> [@](#):
>
> \*Originally posted by rexnervous \*
> \*\*I have two tables of data from different sources. I want to create a new table that takes data from TableA and TableB only if a certain field in both tables match.
>
> I’ve tried various queries but I’m a noob at Access (maybe this can be done in Excel, instead?). Can anyone help?
>
> Thanks in advance. \*\*
Use the find duplicates wizard and then make the query a “make-table” query from any values that the find duplicates locates
---
### Author:  [@Jpeg\_Jones](https://boards.straightdope.com/u/Jpeg_Jones)
#### Post date: [June 26, 2003, 10:43pm UTC](https://boards.straightdope.com/t/simple-ms-access-database-question/184623/3 "2003-06-26T22:43:12Z")
In query builder view, have you tried linking the two fields that should match by dragging the mouse from one field to the other? This should create a link which governs the query results. Then just add the fields you want.