Lookup the field in MSAccess

[rajuganapathyp]

Hi Friends,



Have a good day,

I am a new member to this forum, just started to learn the MS Access. This forum is very helpful to enhance my Access knowledge.
i have a question we have a two tables is available 1 is country wise sales 2nd table have hold the data Country against region (Column A and Column B).
My question is very simple i need to map the data in the 1st Table (country wise sales) country against the Region Column. Please help me to resolve the query. it's very easy in excel we did vlookup and refer the column 2 (Table2) but in Ms Access i wont do that.

Table 1

Sales ID | Country | Sales Qty | Sales Amt

5 UK 10 10000
10 USA 7 8000

Table 2

Country | Region

UK EMEA
USA NAM
CHINA APA
MANILA WCA

Thank you for your quick response.

Rajuganapathy

[pbaldy]

Start a new query and add both tables to the grid. If a join line doesn't get added between the two country fields, click/drag to create one. Now you can return fields from both tables.

[rajuganapathyp]

Hi Paul,

Thanks for your reply, am unable to understand your answer. Herewith I have attached the database sheet, could you please help. Thank you

Myslef unable to attach the file,anyone help me.

[pbaldy]

If you do a compact/repair and then zip, it should be small enough to attach here.

[orange]

raj,

You will do yourself a great favor if you do NOT use field names with embedded spaces.

It seems that you have Sales to Countries that are located in Regions. You don't mention SalesPerson, nor Customer/Client?

Here is a link to Countries by GeoRegion from UN that may be of interest to you.

Good luck with your project.


Sales -->Country--->RegionContainsCountry<---Region