Parameter Query Help

[norm]

I have a table that contains a filed called "Accnt_Code", the data in this
field is from 1A to 9Z, what I need to do is create a parameter quesy, where
the user may input, for example a group of Accnt_Codes, for example 1A to
1Z, and also be able to input individual Accnt_Codes, for example 2A,3B,4G -
it this possible in access?

 

[Allen Browne]

You cannot do that with a parameter query.

You can do it by building a Filter string in code, and applying it to a form
or report. Or you can build the entire SQL statement as a string, and assign
it to th SQL property of the QueryDef.