Hi,
I setup a real estate database using open office. The database is based on a phone survey of potential customers. One of the questions of the survey is "which neighborhoods do you want to live in?" the answers are in a list drop down so you can select multiple neighborhoods in one cell for each potential customer. So for example John Doe Might Say he would live in Lincoln Park, Lakeview or Old Town. How do I filter so I look at all records for just Old Town? All three neighborhoods have been selected from the list and are located in one cell. When I try to do a filter of just Old Town no records appear. I think its because the filter is looking for cells that just have Old Town not Old Town, Lincoln Park and Lakeview. So how do specify the parameters so that it pulls records with more than one neighborhood so long as it has Old Town in it? Thanks for your help. Devin