Filter Record by multiple parameters

I currently running a website where i can filter buy 1 recordset Team and i
need to filter it further by passing attempts.

SQL:
SELECT *
FROM TeamStatsandRoster
WHERE PassingAttempts >= MMColParam
ORDER BY Passingyards DESC

Variables:
MMColParam Default Value and Request("MM_EmptyValue")


Please let me know what i can type in to filter further. thanks

You mean?

SELECT *
FROM TeamStatsandRoster
WHERE PassingAttempts >= MMColParam1
and Team = MMColParam2
ORDER BY Passingyards DESC

You mean?

SELECT *
FROM TeamStatsandRoster
WHERE PassingAttempts >= MMColParam1
and Team = MMColParam2
ORDER BY Passingyards DESC

i get this error when i type that in

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in
query expression 'PassingAttempts >= 1 and Team = arctic blast'.

/arcticblastwebsite/stats.asp, line 24

i get this error when i type that in

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in
query expression 'PassingAttempts >= 1 and Team = arctic blast'.

/arcticblastwebsite/stats.asp, line 24

i get this error when i type that in

Are both parameters populated?

i get this error when i type that in

Are both parameters populated?

the parameters are populated. but i need more explanations on this ?

the parameters are populated. but i need more explanations on this ?