S
StuJol
using access 2003 i have the following qry
SELECT DateSerial(Year([Date/Time*]),Month([Date/Time*]),Day([Date/Time*]))
AS [Date], [AlarmData Table Filtered by Date].[Event Type], [AlarmData Table
Filtered by Date].Parameter, [AlarmData Table Filtered by Date].Desc2,
Count(*) AS MyCount, [AlarmData Table Filtered by Date].Module
FROM [AlarmData Table Filtered by Date]
GROUP BY
DateSerial(Year([Date/Time*]),Month([Date/Time*]),Day([Date/Time*])),
[AlarmData Table Filtered by Date].[Event Type], [AlarmData Table Filtered by
Date].Parameter, [AlarmData Table Filtered by Date].Desc2, [AlarmData Table
Filtered by Date].Module
HAVING ((([AlarmData Table Filtered by Date].[Event Type])="CHANGE") AND
(([AlarmData Table Filtered by Date].Parameter) Like "*OPSUP") AND
(([AlarmData Table Filtered by Date].Desc2)="NEW VALUE = 1"));
im trying to count number of entries per date but keeps returning 1 and
several instances of same date.
SELECT DateSerial(Year([Date/Time*]),Month([Date/Time*]),Day([Date/Time*]))
AS [Date], [AlarmData Table Filtered by Date].[Event Type], [AlarmData Table
Filtered by Date].Parameter, [AlarmData Table Filtered by Date].Desc2,
Count(*) AS MyCount, [AlarmData Table Filtered by Date].Module
FROM [AlarmData Table Filtered by Date]
GROUP BY
DateSerial(Year([Date/Time*]),Month([Date/Time*]),Day([Date/Time*])),
[AlarmData Table Filtered by Date].[Event Type], [AlarmData Table Filtered by
Date].Parameter, [AlarmData Table Filtered by Date].Desc2, [AlarmData Table
Filtered by Date].Module
HAVING ((([AlarmData Table Filtered by Date].[Event Type])="CHANGE") AND
(([AlarmData Table Filtered by Date].Parameter) Like "*OPSUP") AND
(([AlarmData Table Filtered by Date].Desc2)="NEW VALUE = 1"));
im trying to count number of entries per date but keeps returning 1 and
several instances of same date.