MS Access like query with # in the result

I’m just trying to have a query that searches for “#” in a field.

SELECT dbo_PartNumber.*
FROM dbo_PartNumber WHERE (dbo_PartNumber.[Part Number] like  "*#*");

Answer

You have to enclose # in square brackets:

like  "*[#]*"

Find more here Like Operator