Comparing Similiar Data Between Tables In A Query

[jd316632]

I've looked on Google but am not even sure how to phrase this to find an answer. I've got 2 tables in a database, one containing a persons name and a schedule. The other table is updated regularly and contains their clock ins and outs. The problem is the table that is updated with the clockin/clockout will sporadically add the person's username



Example, in the shift table it has their name (i.e. John Smith) and then their work schedule. In the Clockin/Clockout table it will sometimes show John Smith, other times it will show John Smith(JSmith).

As a quick fix for each employee I have 2 records in the shift table, one with the username, one without. What I would like to have is something in place that will either remove the username all together or that will work similar to a like function and will look for "John Smith*"

Any help with this is greatly appreciated. If you need more information please let me know.

[ajetrumpet]

you need to find a pattern. Whatever it is, that's the key.

for instance, if the randomized entries always look like:

john smith (jsmith)

and the regulars always looks like:

john smith

then you could simply check for the existence of a "(" or ")" and compare it to delete those that are invalid or unwanted. For that, you'd use instr() to get it done.

[jd316632]

Found a resolution to this. If interested you can find the result here: http://www.utteraccess.com/forum/Com...8#entry2083418