I have a query that I want to have a parameter where the user enters in the starting quarter and year and the ending quarter and year and the results show everything between. I currently have all of the information going in, but I used between starting quarter and ending quarter. Then in the next field I have starting year and ending year. This gives me all of the information for the quarter range I enter over the years I enter.
Example
starting quarter = 1 Ending quarter = 2 starting year = 2002 ending year = 2003
My results would show all of the events that occurred in the first two quarters of 2002 and 2003. I want it to show everything between quarter 1 of 2002 and quarter 2 of 2003. I am sure there is something really easy here that I am overlooking, but I just cant figure it out any suggestions are appreciated.
Example
starting quarter = 1 Ending quarter = 2 starting year = 2002 ending year = 2003
My results would show all of the events that occurred in the first two quarters of 2002 and 2003. I want it to show everything between quarter 1 of 2002 and quarter 2 of 2003. I am sure there is something really easy here that I am overlooking, but I just cant figure it out any suggestions are appreciated.