clear filter

[amerifax]

Currently this is my method to creates by filter:
I click on the header and select "Text Filters" \ "Contains" and place my value.

I would rather have that like a button which would probably mean creating a form, that would be a major project for my level of knowledge.

have to change the value I'm looking for continuously. And also clear it is many times. I basically use only one field , contains. In the future I hope to have enough skill to be able to add an additional field in my search. Help is needed.


Bob

[amerifax]

I used create query design. I ended up the following:


SELECT [SC-CTY-Type].[SC], [SC-CTY-Type].[COUNTY], [SC-CTY-Type].[TYPECITY]
FROM [SC-CTY-Type]
WHERE ((([SC-CTY-Type].[TYPECITY])="Milwaukee"));


I thought I would able to see Milwaukee since that was one of the items in the database. It displayed nothing.


Bob

[orange]

Try using the LIKE operator (untested) Examples use fictitious city names.

SELECT [SC-CTY-Type].[SC], [SC-CTY-Type].[COUNTY], [SC-CTY-Type].[TYPECITY]
FROM [SC-CTY-Type]
WHERE ((([SC-CTY-Type].[TYPECITY]) Like "[Enter City Name]" & "*"));

The Like operator doesn't require an exact match of all characters.
[Enter City Name] will display a prompt for user to enter characters
The trailing "*" means "any character" -- so if you typed in "Mil" and hit enter you would get cities that BEGIN with Mil
--that could be Milwaukee, Milbury, Milsonville.... as long as the first 3 characters match, you get a positive hit.

If you put the "*" at the start, eg "*" & "[Enter City Name"], then the last characters of the City name would have to match the characters you type in eg Carmil, Crammil,..

If you put in "*" & "[Enter City Name]" & "*", then you would select Cities with names that had the characters you typed in somewhere in the name eg Hommilville, New Milton...