Hope you can all help. I have a query that is approx. 110 statements long. I have a column that we use to filter data in each of these statements called “rpt_mth” this is a char(7) field in the format of ‘yyyy-mm’. This is called about 40+ times. As it is now the users have to find each area and change it for each run. This puts the potential of making mistakes. I have used the prompts function to call it once. However with dealing with other filters you can’t control the way a user enters the data. What I would like to do is set a variable at the begining of the statement strings at the top and declare the rpt_mth. This way the user can see what was there before and adjust one value and that value be used in all of the below statements. Can this be done? If so can you send me an example.