Pull First Name only if there are duplicate last names

[KEKeogh]

Hi all!

Before I do too much research I figured I'd check if this is even possible, since you guys are AWESOME.

I'm using access 2000 to maintain an employee database. There are some times where I am using just last names but need to distinguish between those with the same last name.

I was hoping there was a way that if the [Last Name] field is duplicated the [First Name] field is attached to the end of the [Last Name] Field.

Keep in mind I'm not completely savvy with VBA codes and such.

Thanks in advance for the help.
Kathie

 

[gemma-the-husky]

if the last name on its own is not unique, then you cannot just rely on that name. you need to use both. in point of fact since you may have duplicate full names (ie 2 John Smith's) generally we add a employee number, and use that to identify an employee precisely.

 

[KEKeogh]

Kinda figured that, we have a report that lists the employee's number but then just last name.

We don't need first names for everyone, only those with the same last name.

Like we only have 1 Smith but 2 Jones, so only the Jones would need to have a first name attached.