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="class: grid, width: 102"]
<tbody>[TR]
[TD="width: 72, bgcolor: transparent"]Table 1

[/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Identifier
[/TD]
[TD="bgcolor: transparent"]name
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]1234
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]4321
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]axl001
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]dxl001
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="class: grid, width: 200"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent"]Table 2
[/TD]
[TD="width: 74, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]EmpID
[/TD]
[TD="bgcolor: transparent"]UserName
[/TD]
[TD="bgcolor: transparent"]UserCode
[/TD]
[TD="bgcolor: transparent"]Name
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1234
[/TD]
[TD="bgcolor: transparent"]axl001
[/TD]
[TD="bgcolor: transparent"]al4321
[/TD]
[TD="bgcolor: transparent"]Al
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]4321
[/TD]
[TD="bgcolor: transparent"]dxl001
[/TD]
[TD="bgcolor: transparent"]dl1234
[/TD]
[TD="bgcolor: transparent"]Dave
[/TD]
[/TR]
</tbody>[/TABLE]

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.