WHERE categories.category_type= <<CATEGORY|category_type>>
category_type is an odd one. It's not an authorized value. In fact I don't think they're defined anywhere in the database at all, just hard-coded into templates and scripts. They're intended to be fixed values, not ones which can be modified. I don't think there's any way to get an SQL report to generate a set of options based on these values. It would be nice if one could supply a set of user-defined options in a runtime parameter, e.g. <<Category type|[{A:"Adult",C:"Child"}]>> but that would be complicated for users. I think in your case you might have to rely on good documentation in the report notes to let the user know which category_type codes are valid. -- Owen -- Web Developer Athens County Public Libraries (740) 737-6006 https://www.myacpl.org