Hello all
Sorry if this is applied to the wrong forum.
I have a database the stores data through out the day by time stamp "2012-04-04 02:44:59.000"
What im trying to run a select statment pulling my data and summing it for all of the time stamps that occured today in my data base for today only
was trying to use:
This works on OK in MS ACCESS
Select
""
""
having system_info.date_time)>=Date()+1 And (system_info.date_time)<Date()+2)
but when trying to apply that same statment with the having part in MS query "excel" it errors out.
Was also tried this but no luck
(system_info.date_time = DATEADD(dd,1,GETDATE()) and GETDATE())
So looking for the correct syntax to query my table data and summing it for all the today in MS query "excel"
Thanks SO MUCH...
Sorry if this is applied to the wrong forum.
I have a database the stores data through out the day by time stamp "2012-04-04 02:44:59.000"
What im trying to run a select statment pulling my data and summing it for all of the time stamps that occured today in my data base for today only
was trying to use:
This works on OK in MS ACCESS
Select
""
""
having system_info.date_time)>=Date()+1 And (system_info.date_time)<Date()+2)
but when trying to apply that same statment with the having part in MS query "excel" it errors out.
Was also tried this but no luck
(system_info.date_time = DATEADD(dd,1,GETDATE()) and GETDATE())
So looking for the correct syntax to query my table data and summing it for all the today in MS query "excel"
Thanks SO MUCH...