I have about 4 different queries in a series of queries that all need the same date range that is entered by the user at runtime. I can get the start date and end date using 2 InputBoxes in the VBA but I didn't want to have to manually write all the query SQL in the VBA and use DoCmd.RunSQL, the SQL is very long and cumbersome. I'd rather have it neatly packaged in a query and then DoCmd.OpenQuery. Is there a way to do this using the data from the InputBoxes? If I just run the queries back to back it will have to prompt the user for the dates 4 different times which is very annoying. thanks.