I need to create a parameter query and have run into a problem. Here is the set up. I have an ODBC connection to a helpdesk database. I need to run a query that prompts for the input of two fields, start_date and close_date. To summarize, I need to run a report for tickets opened and closed between 5/1/07 and 5/29/07 (opened and closed being two different fields). The date fields in the origin database is a time date field, so I have used an expression to "crop" the time portion off of both fields. But I can figure out how to run a parameter query to ask for dates between two fields. Can anyone help?