If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
count qry
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. |
Thread Tools | |
Display Modes | |
|
|