VBA Code

[ragnar12]

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?

 

[oldbrewer]

in excel an offset match formula would do it - but are you only using access?

 

[Norie]

This will give you the results you want.

SELECT [Table 1].Field1, [Table 1].Field2, [Table 2].Field2
FROM [Table 1]
LEFT JOIN [Table 2] ON [Table 1].Field1 =[Table 2].Field1

 

[Rick Rothstein]

I'm new to access and I don't really know how....

It looks like you are asking an Access question in an Excel forum. I think you should ask your question here instead...

Microsoft Access

 

[oldbrewer]

	a	14
	b	15
	c	16
	c	16
	a	14
	b	15
		*	**
	a	14	14
	b	15	15
	c	16	16
formula
*	=OFFSET($C$6,MATCH(C18,$C$7:$C$9,0),1)
**	=OFFSET($C$11,MATCH(C18,$C$12:$C$14,0),1)

<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>
</tbody>