Criteria - Containing text

[ApplePirate]

this is probably very simple,,, how do I set the criteria in a query to only return records where a certain piece of text is contained in the field.
i.e Like "*Front Street*" Never ever, bloody anything, ever

 

[GHolden]

This will return NameID and Name from table tblName for all records where Name contains an

SELECT tblName.NameID, tblName.Name
FROM tblName
WHERE (((tblName.Name) Like '*an*'));

There are two ways to write error-free programs; only the third one works.