这个报表如何做,帮帮看看。 如果不用excel 可以吗 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 这是一个竖表变横表的实例sql Server 中用存储过程实现Access 中用transform的命令实现msdn里的一个例子Sub TransformX1() Dim dbs As Database Dim strSQL As String Dim qdfTRANSFORM As QueryDef strSQL = "PARAMETERS prmYear SHORT; TRANSFORM " _ & "Count(OrderID) " _ & "SELECT FirstName & "" "" & LastName AS " _ & "FullName FROM Employees INNER JOIN Orders " _ & "ON Employees.EmployeeID = " _ & "Orders.EmployeeID WHERE DatePart " _ & "(""yyyy"", OrderDate) = [prmYear] " strSQL = strSQL & "GROUP BY FirstName & " _ & """ "" & LastName " _ & "ORDER BY FirstName & "" "" & LastName " _ & "PIVOT DatePart(""q"", OrderDate)" ' Modify this line to include the path to Northwind ' on your computer. Set dbs = OpenDatabase("Northwind.mdb") Set qdfTRANSFORM = dbs.CreateQueryDef _ ("", strSQL) SQLTRANSFORMOutput qdfTRANSFORM, 1994 dbs.CloseEnd Sub 数据库查询的奇怪现象 求动态加载大量控件最快方法。:) 谢谢。 编译错误:找不到工程或库,光标停在MyCon As ADODB.Connection sos!vb6.0的小问题,虾兄、义姐、高手请指点。(online) 如何制作HTML帮助文件,请大家帮帮忙!!拜托???? 哪里有SQL SERVER 2000下载 心情太恶劣了!!散分散分…散光它…散光它!! 在VB中使用MSComm控件发短信但不能触发OnComm下的comEvReceive事件 richedit 中的输入?? 看看代码 我需要一段文件操作的代码!功能如下:(太简单了,我都不好意思问) vb 的远程数据库连接
sql Server 中用存储过程实现
Access 中用transform的命令实现
msdn里的一个例子Sub TransformX1() Dim dbs As Database
Dim strSQL As String
Dim qdfTRANSFORM As QueryDef strSQL = "PARAMETERS prmYear SHORT; TRANSFORM " _
& "Count(OrderID) " _
& "SELECT FirstName & "" "" & LastName AS " _
& "FullName FROM Employees INNER JOIN Orders " _
& "ON Employees.EmployeeID = " _
& "Orders.EmployeeID WHERE DatePart " _
& "(""yyyy"", OrderDate) = [prmYear] "
strSQL = strSQL & "GROUP BY FirstName & " _
& """ "" & LastName " _
& "ORDER BY FirstName & "" "" & LastName " _
& "PIVOT DatePart(""q"", OrderDate)"
' Modify this line to include the path to Northwind
' on your computer.
Set dbs = OpenDatabase("Northwind.mdb") Set qdfTRANSFORM = dbs.CreateQueryDef _
("", strSQL)
SQLTRANSFORMOutput qdfTRANSFORM, 1994
dbs.CloseEnd Sub