I have a parts inventory database. In the database I have a query that
searches by part description. When I run the query a window pop ups and
requests to input a part description. If I put in the complete and exact name
of the part, I get the total number of that particular part in the table.
What I want to be able to do is input part of the actual description name in
the pop up window instead of the complete name and get the same results. In
other words if I'm searching for a modem, I want to be able to input modem or
mod and get the same results. I guess something like a wild search.

This is my SQL:        
SELECT tblSiteInventory.ID, tblSiteInventory.Region, tblSiteInventory.State,
tblSiteInventory.Site, tblSiteInventory.PartDescription,
tblSiteInventory.PartNumber, tblSiteInventory.[Total On Hand],
tblSiteInventory.[Total Repair], tblSiteInventory.Date, tblSiteInventory.Tech
FROM tblSiteInventory
WHERE (((tblSiteInventory.PartDescription)=[Input Part Description]));

Thanks for the help,
V3M (not an expert in Access)