populating a name based on one of three user ids in a table

[Ka0ticSt8]

Is it possible to populate a field in a table based on the entry of one of three user id's in another field?

I would like to populate the name field in Table 1 that associates to the Identifier based on the information in Table 2.

Table 1
Identifier	name
1234
4321
axl001
dxl001

<tbody>
</tbody>

Table 2
EmpID	UserName	UserCode	Name
1234	axl001	al4321	Al
4321	dxl001	dl1234	Dave

<tbody>
</tbody>

All help welcome.

I'm between a basic and intermediate user of Access.

 

[xenou]

I have the totals, however 19717, RJN000 and D3442 are the same employee and are listed on different rows. The problem is I need the combined totals.

I edited the previous post for this scenario as well.

 

[Ka0ticSt8]

That did it.

I heard what you said earlier, but was not able to get it done.

This is exactly what I needed.

Thank you all.

 

[xenou]

No problem. I wanted to refer back to the earlier discussion because that's where the explanation of the ideas are - the last two posts were just examples of implementation.