2 fields = same data

H

HeyTriciaC

I have 2 queries that I cannot for the life of me figure out how to join.
Basically one has a field titled StoreID and the other query has one titled
StoreID1. They are the same data inside but I cannot link them since they
are not the same name. Is there some way that I can tell it that StoreID1 is
= to StoreID?
 
V

Van T. Dinh

Join Fields don't have to have the same name.

In the Table pane of the Query, just drag the linking Field from one Table
and move it to on top of the corresponding linking Field in the other Table.

Note: depending on the type of link you want (Inner Join / Left Join / Right
Join), you may need to right-click on the linking line created by QBE and
then select Properties to modify the join type. The default in Inner Join.
 
Top