I have a search form with minimum and maximum age text fields and need to return results to reflect that. For example, if a user wants to find people aged between 25 and 30, they put 25 in the 'minimum' box and '30' in the maximum box. To set up the Recordset SQL filter criteria for this, I have written this code:

SELECT *
FROM Settings
WHERE Age >= 'MMColParam6' AND Age <= 'MMColParam7'

where MMColParam6 is Request("fmSearchAgeMin" and MMColParam7 is Request("fmSearchAgeMax".

When I hit the Test button in the Recordset window it gives the error "Data type mismatch in criteria expression".

Any ideas anyone? Do I need to convert the form variables into numeric variables before >= and <= operators will work?

Thanks

Tim

If Age field is number then remove '' signs, they are used only if field is of text type.

SELECT *
FROM Settings
WHERE Age >= MMColParam6 AND Age <= MMColParam7

Thanks, it's sorted now.

I have since learnt that you can also use BETWEEN instead of mathematical symbols, ie

SELECT *
FROM Settings
WHERE Age BETWEEN MMColParam6 AND MMColParam7

instead of

SELECT *
FROM Settings
WHERE Age >= MMColParam6 AND Age <= MMColParam7

which is useful to know.