need help with access query

[gkcy]

I need help to do a query to find a field value from similar fields. Table 1 has fields(customer id,...) and table 2 has fields (customer id, address,...). I need to use customer id from table 1 to find address in table 2. Both customer id fields in both tables is the same.

 

[Brianwarnock]

Read about Joins.
You need to join the tables on the common field.

Brian

 

[maximark]

If you have CustomerID in Table2 and that is what you want to look up the address for then Table1 doesn't matter. Just search Table2 for the CustomerID and Address.

 

[gkcy]

(maximark)-not possible. i'm supposed to automate it. If I search it from the table; that is already using the manual filter table process. (Brianwarnock)- I have read little about joins and joined my table but the problem is building the expression for the query field. I need the field to take customer id from table 1 and search table 2 using the id

 

[Brianwarnock]

But in simple terms that is what a join does, it joins the records from different sources eg two tables, based on selected fields being equal.

Brian