Show only people who match multiple paramaters

[Supe]

I have a query the runs off a form that that has 5 different fields. How do
I set it up so the query only pulls data that matches all the paramaters?

For example, I want to find people have a salary above $40,000 AND a rating
above 4. If I run now it shows eveyone that has a salary about $40,000 OR a
rating above 4.

 

[KARL DEWEY]

Post you query. Open the query in design view, click on menu VIEW - SQL View,
hightlight all, copy, and paste in a post.

 

[Supe]

SELECT [Pitchers-Proj].PITCHERS, [Pitchers-Proj].[First Name],
[Pitchers-Proj].[Last Name], [Pitchers-Proj].[$], [Pitchers-Proj].Team,
[Pitchers-Proj].W, [Pitchers-Proj].K, [Pitchers-Proj].ERA,
[Pitchers-Proj].WHIP, [Pitchers-Proj].SV
FROM [Pitchers-Proj]
WHERE ((([Pitchers-Proj].[$])<=[Forms]![Pitcher Spec Data]![cost]) AND
(([Pitchers-Proj].W)<=[Forms]![Pitcher Spec Data]![Wins]) AND
(([Pitchers-Proj].ERA)<=[Forms]![Pitcher Spec Data]![ERA]) AND
(([Pitchers-Proj].WHIP)<=[Forms]![Pitcher Spec Data]![WHIP]))
ORDER BY [Pitchers-Proj].[$] DESC;

 

[KARL DEWEY]

Try this --
SELECT [Pitchers-Proj].PITCHERS, [Pitchers-Proj].[First Name],
[Pitchers-Proj].[Last Name], [Pitchers-Proj].[$], [Pitchers-Proj].Team,
[Pitchers-Proj].W, [Pitchers-Proj].K, [Pitchers-Proj].ERA,
[Pitchers-Proj].WHIP, [Pitchers-Proj].SV
FROM [Pitchers-Proj]
WHERE ((([Pitchers-Proj].[$])>=[Forms]![Pitcher Spec Data]![cost]) AND
(([Pitchers-Proj].W)<=[Forms]![Pitcher Spec Data]![Wins]) AND
(([Pitchers-Proj].ERA)>=[Forms]![Pitcher Spec Data]![ERA]) AND
(([Pitchers-Proj].WHIP)<=[Forms]![Pitcher Spec Data]![WHIP]))
ORDER BY [Pitchers-Proj].[$] DESC;

--
KARL DEWEY
Build a little - Test a little

SELECT [Pitchers-Proj].PITCHERS, [Pitchers-Proj].[First Name],
[Pitchers-Proj].[Last Name], [Pitchers-Proj].[$], [Pitchers-Proj].Team,
[Pitchers-Proj].W, [Pitchers-Proj].K, [Pitchers-Proj].ERA,
[Pitchers-Proj].WHIP, [Pitchers-Proj].SV
FROM [Pitchers-Proj]
WHERE ((([Pitchers-Proj].[$])<=[Forms]![Pitcher Spec Data]![cost]) AND
(([Pitchers-Proj].W)<=[Forms]![Pitcher Spec Data]![Wins]) AND
(([Pitchers-Proj].ERA)<=[Forms]![Pitcher Spec Data]![ERA]) AND
(([Pitchers-Proj].WHIP)<=[Forms]![Pitcher Spec Data]![WHIP]))
ORDER BY [Pitchers-Proj].[$] DESC;

Post you query. Open the query in design view, click on menu VIEW - SQL View,
hightlight all, copy, and paste in a post.