Vlookup functionality in Access [ Lookup from other table]

[S2Kool]

Hi Team,

I have two table without any primary key.

Table1 : Week number , YEAR

Table 2: Week number, Month

how to add a query which can give me : Week number, Month and YEAR ( based on Table 1 & Table 2).

if its important to create the relationship first, then how to create a query which can add unique ID in table 1 and Table 2? currently data in table 1 and table 2 are straight coming from excel macro, hence I don't want to touch that table to create the ID's as primary Key.

appreciate your help.

 

[Joe4]

In your relationship, you would join the two tables on your Week Number field, since that is your common field.
Any unique ID field would be stored on the Table level, not the Query level.
For that, I would just recommend adding an Autonumber field to your table.

If you want to create a unique primary key field, maybe something that is a combination of weeknumber, year, and month, you would probably use a Make Table or Append Query, to write the records to a new table, where you can build a unique primary key field off of a combination of the weeknumber, year, and month fields.

 

[S2Kool]

Thanks for your quick response. will apply above suggestion.