Taking Data from another Table

[AnnaVilj]

Hi All

I have a quick query. I have a table with a Account Code and its relavant Account Name.

What im tyring to do is in a query or another table, which has 17000 rows of data and the account code has been used in each entry. What i'm trying to do is to be able to create another column where the relavant Account Name can be next to Account code in the query or table.

Could someone please help.
Thanks
Anna

 

[Michael J Ross]

Create a query by going into Queries and click on Create Query in Design View, add the two tables and join by account code (to do this click on the account code in the first table and drag it across to the account code in the second table) , then you can put the columns you want to see in the grid below where the tables are by dragging and dropping from the tables into the grid. You can put the columns in any order you desire so simply put the account name column next to the account code column in this grid. Click the red ! to run the query.

 

[AnnaVilj]

Hi Michael thanks for the help it works