I Have a database crosstab query that runs fine in MS ACCESS, but returns no records in my asp page.
Can these types of queries run in ASP? I do a lot of programming using databases and am sure the code is correct, but the results are not returned. Regards Pete PS, for those who want to see, here is the query; TRANSFORM Sum(IIf([vat],[takings]/1.175,[takings])) AS SumOftakings SELECT dates.WeekNo FROM departments INNER JOIN (([business units] INNER JOIN [n-weeklytransactions] ON [business units].buID = [n- weeklytransactions].businessUnit) INNER JOIN dates ON [n- weeklytransactions].ztotaldate = dates.Startdate) ON (departments.bus_unit = [n-weeklytransactions].businessUnit) AND (departments.department = [n-weeklytransactions].department) WHERE ((([business units].business_unit)='Shop') AND (([n- weeklytransactions].weekendingdate)>#12/31/2004#)) GROUP BY dates.WeekNo, [business units].business_unit, [n- weeklytransactions].weekendingdate ORDER BY dates.WeekNo, [n- weeklytransactions].department PIVOT [n- weeklytransactions].department; ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hbsrag9/M=362329.6886308.7839368.1510227/D=groups/S=1705006764:TM/Y=YAHOO/EXP=1123512709/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992 ">Fair play? Video games influencing politics. Click and talk back!</a>.</font> --------------------------------------------------------------------~-> ASP Resources www.asp-dev.com ============================================================ Learn over lunch. Get the developerWorks newsletter and enjoy tools, code, and tutorials, along with your sandwich. XML, Linux, Web services, Java -- and peanut butter! http://www.topica.com/partner/AP-1RMZ49/partners/ibm/aff_landing.html ============================================================ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/asp/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
