Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 Crosstab and Filter
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Average Member

845 Posts

Posted - 25 March 2008 :  07:25:26  Show Profile
I have a Crosstab Query in Access.

TRANSFORM Count(Mortgage.MortID) AS Total1
SELECT Mortgage.LeadDate, Count(Mortgage.MortID) AS Total
FROM Mortgage
GROUP BY Mortgage.LeadDate
PIVOT Mortgage.QCStatus;

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. "

Edited by - kolucoms6 on 25 March 2008 15:46:00

Support Moderator

United Kingdom
2897 Posts

Posted - 26 March 2008 :  09:38:51  Show Profile  Send pdrg a Yahoo! Message
Crosstabs are flaky and really not at all suited to ASP as the size and shape of the resulting dataset will change with every single query.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.22 seconds. Powered By: Snitz Forums 2000 Version 3.4.07