Multi-Field Search issues within Query

[stiracerdude]

Hello I am doing a project for class and I am just stumped on multi field


search. I'm sorry if this in the wrong section but I believe my issue in within
my query, but I'm not sure.

I have a form that has text fields with
Location, Zip, Shelters, and Counseling. Also a Run Query button

FYI
Shelters and Counseling are text but are designated with a Y or N

When I
search by location or zip I have no problems at all, but say I search by
location and shelters. I then get my correct location, but shelters is showing
all shelters data within the correct location

I am a beginner with Access. Also the version I am using if it matters is
2010


below is my SQL View

SELECT Contacts.Agency,
Contacts.Location, Contacts.[ZIP/Postal Code], Contacts.Shelters,
Contacts.Counseling
FROM Contacts
WHERE (((Contacts.Location) Like "*"
& [Forms]![Search Form]![Location] & "*") AND ((Contacts.[ZIP/Postal
Code]) Like "*" & [Forms]![Search Form]![zip] & "*") AND
((Contacts.Shelters) Like "*" & [Forms]![Search Form]![Shelter] & "*")
AND ((Contacts.Counseling) Like "*" & [Forms]![Search Form]![counseling]
& "*"));

Thanks

[June7]

So when "Y" or "N" is selected as criteria, still returns all shelters? Every record has either Y or N, no empty fields? The query looks good to me. If you want to provide db for analysis, follow instructions at bottom of my post.

[stiracerdude]

So when "Y" or "N" is selected as criteria, still returns all shelters? Every record has either Y or N, no empty fields? The query looks good to me. If you want to provide db for analysis, follow instructions at bottom of my post.

Thank you for responding. To answer your question yes each record has either Y or N. I think I fixed my problem. I changed it to LIKE[Forms]![SearchForms].[Location] & "*" instead of Like & "*" [Forms]![SearchForms].[Location] & "*". This seemed to fix my problems. I found this link late last night and tried it this morning. http://www.datapigtechnologies.com/f...earchform.html

[June7]

The controls used to input criteria are unbound? Are they textboxes or comboboxes?

Whether or not the prefix wildcard is needed depends on the input. If it is a textbox where you allow free entry of value and you want to allow search match on values like "East Mountain View" or "West Mountain View" when user inputs only "Mountain", then both wildcards are relevant.

DataPigTech has quite a few tutorials you will probably find interesting.