ASP code for Month & year Report.

[hemmca]

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.



Thank You.

[buntine]

Should be more like this:

strsql = "select * from domestic where city='" & city & "' and Date between #" & month1 & "/01/" & year1 & "# and #" & month1 & "/31/" & year1 & "#;"

Note, it can be risky to name a field "Date" as it is a reserver word and may cause problems.

Regards.

[phpnovice]

Just surround your table names and column names with square brackets to avoid getting them confused with SQL syntax keywords and functions.

[hemmca]

Dear Sir/Madam,


Thank you for replying,
but it gives the same output(If I choose any year or any month,it gives the same Report).

[buntine]

Is Date a column in your table?