Unanswered: Access Query Using User-Specified Criteria
I need to create a query/report in Access 97 that will return all records containing any part of the text entered by the user.
I have a field containing graphic codes for artwork. The codes are made up of letters and numbers--the letters representing team name and the numbers representing design series (ex. IND1517). I need a search that will allow users to enter any part of the graphic code and return all records containing that user-entered data. I have tried things such as >=[Enter Graphic], but this returns everything listed after their entry. It also does not allow the users to search by the series number (i.e. the 1517 part).
Can anyone help to point me in the right direction?
(p.s. Please go easy on me...this is my first post