I am using ASP and MS Access.
strsql = "select * from domestic where city='" & city & "' and Date between '" & month1/01/year1 & "' and '" & month1/31/year1 & "'"
I want to view the Report of particular city,month and year.
If I select the city=Bangalore,month=May,Year=2005,Then It shows the Detail Report for the above query.
But I am getting same answer( Detail Report) for selecting any month and year.
Please give me the code for this.