I need to create a report that will show the list of data that is within that range of period.
The scenario will be:
- the user will choose the starting month and the ending month from a drop down list. (for example, starting month = July and ending month = September)
- then the report will be showing all the data within that range of month chosen by the user. (data from July until September will be shown, including data from the month of AUGUST)
- the problem I'm having is that when I choose the starting month and ending month as shown above, I only get the data from the month of JULY and the month of SEPTEMBER, the data from month of AUGUST will not be shown.
I'm not sure on how to write the SQL statement???
Needed help from anyone who knows how to solve this porblem.. Thank you..
View Complete Post