Parameter crosstab queries and multiple values

[hyperiest]

OK, took a week off and re-grouped -- now back in the office for some catch-up work.

I have all but conquered the SQL for parameterized queries, but now another twist: how do you write the SQL statement for a parameter query when you want to be able to query records based on a single or multiple values? I have the code for how to include all records based on a null value, but this one is stumping me at every turn.

Does anyone know how to do this?

CPT D

 

[fredk]

I am not an expert in SQL but I find it helpful to create a query in design view with the parameters I need and then change the query view to sql.

Hope that helps!!!

Fred