I have a Crosstab Query in Access.
TRANSFORM Count(Mortgage.MortID) AS Total1
SELECT Mortgage.LeadDate, Count(Mortgage.MortID) AS Total
GROUP BY Mortgage.LeadDate
In ASP page, I want to run a filter as
adRs.Filter=session("DateType") & " between #" & session("FromDate") & "# and #" & session("ToDate") & "#"
But I am getting an error as
ADODB.Recordset error '800a0bb9'
"Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. "