I'm new to access and I don't really know how to ask it to do what I want it to do. I need two columns to match, although side by side they do not. It will work as more of a Find function I would assume. I realize sql is the normal language, but am having trouble getting it to work (since I am not sure what to tell it).
So it may originally look like:
Table 1
a 14
b 15
c 16
Table 2
c 16
a 14
b 15
Need it to match and look like:
New Table (Query)
a 14 14
b 15 15
c 16 16
Any suggestions?
So it may originally look like:
Table 1
a 14
b 15
c 16
Table 2
c 16
a 14
b 15
Need it to match and look like:
New Table (Query)
a 14 14
b 15 15
c 16 16
Any suggestions?