Need help with Query (Some names with "*")

[The_Vincester]

I have a large database that I need to add a "Team" (Pacific, Easter, Central) in front of each entry. Each enter has the name of an Editor, which is easy enough since they are assigned teams and another table has their names with the team they are assigned.

The tough part (for me) is that sometimes they used a "*" at the end of the names to indicate that it had a certain property (shared with someone else).

The thing is, I can get the query to show the names with the "*" at the end.

Is there a Like statement that I could use? I've tried a lot of different things, but nothing seems to be working.

 

[KeithG]

Yes you can use the Like statement in a query. Can I ask why they would do such a thing in the first place (I am talking about puting the asterik at the end of the name). I would end this process and make a boolean field in your table to store this info.

 

[The_Vincester]

Wasn't my decision. I was brought in after any of these decision were made and believe me, it will be changed going forward.

I'm basically pulling in 6,000 Excel sheets, adding a date column and a "Team." It's all worked out so far, but for some reason I can't get this part to work.

I've been working on some much "difficult" stuff that this seemingly easy query is causing me confusion. It's probably so easy I'm overlooking it.

...I can't seem to the the Like statement working, though...

 

[KeithG]

I made an example for you. Is this what you want?

 

[The_Vincester]

Not really.

I've modified what you uploaded to show...

What you'll see is a list of name (sans "*") where they're assigned to team, then you'll have your list with the "*" at the end of their names as well.

Then the query where I want to have each name (even with the "*") to have a Team next to it. The thing is that the only "relationship" is the name. I could create a table that has two sets of names (one with and one without "*"), but that seems fairly ineffient and we're talking about 300+ names as opposed to 5 or 6.

Thanks for your help, I know there's a way!

 

[The_Vincester]

edit: Double posting, sorry.