As you can see, it is like that in several of the last names.

Use And " Not Like " in the criteria.

If you want only the last names that have no comma but are the same as the ones with commas

Like [Forms]![MainTableForm]![EnterLastNameTextBox] & "*" And Not Like "*" & [Forms]![MainTableForm]![EnterLastNameTextBox] & ","

If you want all the books whether there's a comma or not then just use the Like function -- see Richards search form videos.

Show us your query in design view.

-Raymond

Ken  If you want to remove all the commas in the column, you can use Find & Replace in table view.  Make sure you click on the first row of the column with the commas, and choose to make changes only in the current column.

Thanks, Stanley, I will give that a try. Raymond, I will attach a screenshot of the Query next. I wasn't sure if it would be an append query that needed to be made or something else. Still not that great with complicated queries. Kevin, I tried that, but when I do it in the first row of the column, it never shows the comma; however, as you can see, they are clearly there. I just need to remember the next time I import anything from Excel to be sure to double-check things like that. Thanks, guys, and I just know there has to be a simpler way than going down each row and removing them one at a time.

Hey Guys, I just found the answer to get the results I needed. Thank God I backed up that database several times. The answer was...Update Query:
Criteria:         Right([YourFieldName],1) = ","
Update To:   Left([YourFieldName],Len([YourFieldName])-1)

Commas are all removed. Now I can continue to work on that Search Form

Well done Ken -- was going to mention an update query but they can be dangerous things for data and some data from other sources is not allowed by corporate to be changed. Was going to ask if it was possible to change the data first. Looks like is was.