Someone to modify my database

[proberts2014]

I am working in a database, just a user, and really need a small search feature added, would someone be willing to help me? thanks

[June7]

If we knew more about what you wanted to do, might be able to advise. In the meantime, review:

http://www.datapigtechnologies.com/f...tomfilter.html

http://www.allenbrowne.com/ser-62.html

[proberts2014]

Sorry June7 for not being more specific, I will look at these links you provided. I want to be able to perform a search of all entries made, within the entry there is a field that has a coding (ie 031-200218-0101-1613), it is the last 4 digits of this field I want to search with. There are currently more than 36000 entries and I need to be able to pull all entries for a specific 4 digit code. This 4 digit code is referring to a building. If it is more helpful and you are willing I can zip the database and attach to a post.

[June7]

Using first method (dynamic parameterized query), form RecordSource could be like:

SELECT * FROM tablename WHERE Right([fieldname],4) = [Forms]![formname].[controlname];