datePartName = ""; switch(rs.criteria.numDays) { case "120": units=6; datePartName = "month"; subtitle = "Last 6 months"; break; case "360": units=12; datePartName = "month"; subtitle = "Last 12 months"; break; case "7": units=7; datePartName = "day"; subtitle = "Last 7 days"; break; case "30": units=30; datePartName = "day"; subtitle = "Last 30 days"; break; case "60": units=60; datePartName = "day"; subtitle = "Last 60 days"; break; case "1": units=24; datePartName = "hour"; subtitle = "Last 24 hours"; break; case "0.5": units=12; datePartName = "hour"; subtitle = "Last 12 hours"; break; case "0.25": units=6; datePartName = "hour"; subtitle = "Last 6 hours"; break; case "0.125": units=3; datePartName = "hour"; subtitle = "Last 3 hours"; break; case "0.0417": units=60; datePartName = "minute"; subtitle = "Last hour"; break; } SELECT count(*) as numCount FROM qryData WHERE entry_minute=#minute(theDate)# and entry_hour=#timeFormat(theDate,"H")# and entry_day = #day(theDate)# and entry_month = #month(theDate)# and entry_year = #year(theDate)# entry_hour=#timeFormat(theDate,"H")# and entry_day = #day(theDate)# and entry_month = #month(theDate)# and entry_year = #year(theDate)# entry_day = #day(theDate)# and entry_month = #month(theDate)# and entry_year = #year(theDate)# entry_month = #month(theDate)# and entry_year = #year(theDate)# Timeline (#subtitle#)