关于"查询"问题~~thx^_^

icarus24

aXo3YYzT.rar (24.29 KB, 下载次数: 7)

2006-8-30 02:56 上传

点击文件名下载附件
关于"查询"问题~~thx^_^

请问怎样在"chart" form 可以修改 "Court_Fault" 这个查询呢?

因为我想用家可以自行选取日期　显示报表

谢谢︿＿︿

lix

参数查询可以吗？

PARAMETERS UserDate DateTime;
SELECT DISTINCTROW FaultyCode.FaultCode, Count(Incident_Detail.FaultCode) AS Count_Fault, Incident.CreatedDate AS I_Date
FROM Incident INNER JOIN (Incident_Detail INNER JOIN FaultyCode ON Incident_Detail.FaultCode = FaultyCode.FaultCode) ON Incident.Incident_ID = Incident_Detail.Incident_ID
GROUP BY FaultyCode.FaultCode, Incident.CreatedDate;