The advanced recordset dialog box allows you to basically type in an open query. You can just hardocde variable names into the query, as long as you follow mysql syntax.  7 of 9