Coding Help - Filter View

[site4sure]

Hi,

I am not very savvy with Lotus Designer yet, I'm just working my way around. I have this view created where I can filter by certain fields I have defined. The code is as followed:

SELECT (Form = "Contact") | (Form = "Person") & !RemoveDoc = "Yes" & COZip = "82601"

With that code, I can see just the 82601 documents in our database, but I want to be able to see like 82601, 82602, etc.etc in the same view. Can anyone help?

 

[lespaul]

Just to clarify, you just want the first three characters of the field COZip to match?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[site4sure]

I actually want all characters to match. I have a list of zip codes that I need to pull records from in this database. For instance, 82601, 82602, 82604, 82609.

 

[pmonett]

If you want all zip codes to match, what is the use of testing the zip codes in the view ?
What you would probably be more interested in is controlling zip code input by using a dialog box that allows the user to choose among your approved zip code list.
That way you do not need to worry about zip codes in the view.

Pascal.